Jamroom for Review website

I am currently running a business review website built on wordpress and have close to 1 million businesses listed and getting reviews. Our traffic is between 2500 to 5000 users per hour. Lately the site is becoming really slow because of more listings, wordpress plugins and limitation on wordpress. I want to use Jamroom to develop my new site, what are the limitations on Jamroom. How big can the database be, the speed of the software, can it be programmed to what I want or would it be really hard. Can my existing database be imported from wordpress to jamroom.
Thanks for answering in advance.
updated by @msultani: 10/13/16 06:57:43PM

Hi - Thanks for the enquiry.
There are 'live' Jamroom sites that have 10s of 1000s of members and list 100s of 1000s of items that run without issue and at acceptable speeds. We have also tested Jamroom with in excess of 1,000,000 item listings without issue, so yes, I'd say there would be no problems there.
Being able to serve your site to up to 5000 visitors an hour is down to server performance and I would say that you definitely would need a dedicated server to do this. If you do not have one already, checkout our Hosted packages that provide dedicated VPS Linode servers set up specifically to provide the highest Jamroom performance possible - https://www.jamroom.net/hosting
Can you point us to your WordPress site so that we can look it over and advise on how it might be replicated with Jamroom? (Email the url to support[at]jamroom[dot]net if you do not want to publish the url here).
Thanks
Paul


--
Paul Asher - JR Developer and System Import Specialist

Hello Paul,

Thanks for the response, I will send an email with the site url to you. I used Jamroom about 10 years ago, and I remember my site had limitations at that time with about 60,000 users and Brian was aware of it. As you are aware review sites use Geolocation and also displays maps of the business on their page. Is there an option available for Jamroom that allows this. As you mentioned dedicated servers are the only options for us right now and I have other software installed for Apache to speed up a few things, which I don't know if it is an option with Jamroom, like Cassandra, and few more.

Thanks
Amin

Hi Amin - and welcome back to Jamroom

JR does not use Cassandra - it uses MySQL (although I would recommend Percona or MariaDB 10.1 instead for maximum performance). We also have a MemSQL plugin that is in development that might work for you if it turns out the performance on specific datastores is not high enough.

JR has a Geo Location module, so that should not be an issue, but note that it does NOT support Geo Fencing or radius searches currently.

One million entries in a Jamroom DataStore will work just fine, but does depend on the number of "search" parameters used to generate a list. In this instance we would want to limit our search to one or two search conditions max - any more and the query is going to be very slow.

If you can provide more details on how your business locations are presented, that will give us a better idea if JR would be a good fit.

Hope this helps!


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net

Hello Brian,

Thank you for answering some of my questions. I did send you an email with more info and links. Speed is one of the major things for us, unfortunately we do not get that from wordpress and their plugins. As you are aware if the page does not load within 1 sec, users will abandon the site. Searches will be done by name or keywords in the given city. We currently have 40,000 cities in Canada and US in our database and expecting to expand to 5 other countries. My goal is to have dedicated servers because hosting can not handle our site. Currently with 5 servers on google cloud, the site is slow.
For Jr, will RAM be import or CPU, since our site will be having images, reviews, stats and so on and user activities. There will not be any music, videos hosted. What will you recommend for a server and how many businesses, users per server. Is there a mobile app for JR or no. Can we have categories and sub-categories and will hashtags be allowed for keywords.

Sorry for I am asking to many questions, but as they come to me, I try to get answers.

Thanks