Hello,
I have this project where I need to collect bets on a soccer competition.
The process is as follow :
- new visitor authorizes Facebook to get his datas and it creates a new WP user ;
- one registered, the user sees a CRED form that allows him to make his bets (fields "team 1 score" and "team 2 score") ;
- the submission creates a new post (CPT "Bets").
Problem is I have about 2000 bets on each match, and the competition has 52 matches.
So I'm expecting to have about 100,000 matches... so 100,000 posts created.
But for a few days, I already noticed a slowing down of the website, which has already registered 5000 users and 30,000 bets.
So I am wondering if I made the right choice about the whole structure for this ?
For instance, I was also thinking of repeatable fields, but it looks like they also created as posts.
How would you build such a game ? maybe Toolset is not the right tool at all ?
Thanks a lot for your advices.
I don't think having 100k posts alone will cause problems with Toolset. If you're trying to do calculations based on those numbers, or performing complex search and filtering on those results, or mapping results, then depending on the complexity it could have a negative impact on site speed. Sometimes caching those values is helpful. Lots of other factors influence site speed too, like how many Users are active on the site, how fast the server is, the PHP or MySQL versions installed, and so on. You can install the Query Monitor plugin and monitor the site's performance to get a better idea of what's happening. You can also use webpagetest.org as a testing system to get some information about where the problems are.
My issue is resolved now. Thank you!
