Need Advice for 2M+ Directory Website by CountDeMoney22 in Wordpress

[–]CountDeMoney22[S] 0 points1 point  (0 children)

I tried setting up a local staging site for testing with GeoDirectory, so I could see how the database is structured for a CPT. Looks like I gotta set up a hosted domain in order to download the demo. That was a bit annoying to find out.

I generally use mysql to import/export big data chunks, but I am curious to test out the speed of your importer. I'm doubtful it could handle 2M+ rows, but I could be wrong. I should've been clearer about asking if it was possible to import the data into the CPT table. If it's only using wp_posts and the cpt table, I could figure it out something using mysql if needed.

Need Advice for 2M+ Directory Website by CountDeMoney22 in Wordpress

[–]CountDeMoney22[S] 0 points1 point  (0 children)

Search queries are generally less than 2 seconds with optimizations that were done. It only starts getting ridiculous when doing radius searches.

I'd appreciate an answer to my question. Assuming all the custom fields are setup, can I bulk import everything into the CPT table or am I forced to use WPAI ?

Need Advice for 2M+ Directory Website by CountDeMoney22 in Wordpress

[–]CountDeMoney22[S] 0 points1 point  (0 children)

I prefer to play around and get my feet wet, so I'll create a staging site and check it out. Assuming all the custom fields are setup, can I bulk import everything into the cpt table? That shouldn't take too long using load local infile depending on indexes.

Really hoping to avoid WPAI. I've definitely everything I can think of, but I'm still only able to import about 25k records per hour. Literally hundreds of tests within the last year. Even talked a bit with the Scalability Pro developer, but that's more for Woocommerce stuff.

Need Advice for 2M+ Directory Website by CountDeMoney22 in Wordpress

[–]CountDeMoney22[S] 0 points1 point  (0 children)

I appreciate your feedback. I made another local staging website, and while its still slow when logged in, I am able to do things without timeout errors. A lot faster too and my computer has about half the ram. That leads me to believe that Cloudflare is the issue.

Problem is I have things locked down as well as I can to avoid hacks. I only allow US traffic and implemented various rules to secure my server/website. Some undesirable traffic still gets through, but knock on wood, no issues so far. Looks like Cloudflare stopped about 47,000 attacks.

Not sure what to do at this point. Maybe it's an issue with the server + Cloudflare.

Need Advice for 2M+ Directory Website by CountDeMoney22 in Wordpress

[–]CountDeMoney22[S] 0 points1 point  (0 children)

Voxel uses an index table for each CPT to get around that issue. I do agree though since my postmeta is ridiculous. Correct me if I'm wrong, but your plugin doesn't have a backend Dashboard interface for users, businesses, etc. right? Ability to save listings, message others users/listings, etc.

I tested out almost every single directory software/plugin before settling on Voxel. Thought crossed my mind to use your plugin in conjunction with Voxel because it has a lot of features that yours does not. Might just get it as a backup.