• Resolved arasu

    (@arasuseithi)


    I am having 2 directory plugins in mind.

    One is geodirectory and another is directorist. I am fully confused which one to choose.

    Kindly help me selecting the right one as per my requirements.

    1. I would like to build an all in one directory website which should have all the features.

    2. I am going to list more than 1 million listings. I have database of 2 million listings.

    3. Website speed is utmost important for me.

    4. This should take less server resources like CPU and RAM.

    5. Should work well with caching plugins like WP rocket and Redis cache should work.

    6. Search result should load instantly even it has millions of listings.

    Do you know one of the theme which is “mylisting” ? This theme is similar to your plugin. Do you have any idea about it? What makes you better than all others ? What difference do you think that your plugin is far better than geodirectory? Do you think your code is cleaner than geodirectory? Do you think your plugin used website loads faster than geodirectory? Did you checked your plugin with geodirectory ?

    Please answer, it is very important to know this before I choose the plugin.

Viewing 2 replies - 1 through 2 (of 2 total)
  • Hi there, thank you taking your time to share the feedback.

    Sure, I will guide you to pick one of them as per your requirements.

    1. Directorist and Geodirectory are both pretty much good solutions for a directory business but both of them have their own control or limitations you can say.
    2. A good amount of our customers are already handling such databases with Directorist, and there is a lot to improve for optimization still now. Not much idea about Giodirectory.
    3. Understood.
    4. Good server configuration is also a key factor in such cases.
    5. Please try out a demo server with that amount of listings.
    6. We are improving on this gradually.

    Please have a look at this article which is written by one of our best content strategists Suza Ad Dowla https://directorist.com/blog/geodirectory-vs-directorist-comparison/ and hope you can find your answers. If you need more details, kindly reach out here https://directorist.com/contact/

    Feel free to let me know for more help.

    Regards,
    Sheikh Faysal

    Thread Starter arasu

    (@arasuseithi)

    Dear team, 

    Kindly answer me this in detail. Its very important for me to choose your plugin. I mailed you too, but still no reply from past 4 days. That’s why i compelled to write you here.

    Is it your plugin uses wp_postmeta database table to store custom field data?

    Is it your plugin creates 1 row for each custom field?

    How you store the data in database, do you use your custom table to store data?

    I read one article in GeoDirectory, which is below

    WordPress Custom Fields Scalability Limits

    WordPress by default uses the wp_postmeta database table to store custom field data, and it creates 1 row for each custom field used in a post.

    Other than that WordPress adds a lot of extra data in this table for each post, each of which will use 1 row of the table.

    If you spent some time optimizing SQL queries, you’ll know that’s not an ideal scenario for things like directories and filtering.

    In fact, the default database structure is potentially a huge bottleneck for websites with many posts and custom fields.

    It is considered one of WordPress’s weak points.

    This is because to filter posts by custom fields, you’ll have to join the wp_post table with the wp_postmeta table in your query.

    The bigger the tables will grow, the slower the queries will become.

    Worst of all if you want to filter by two meta values, you would need to join the post_meta table twice to do it in one query.

    This can eat up system memory and drag things down for anything but a small directory.

    Full article link, – https://wpgeodirectory.com/advanced-custom-fields-does-not-scale/

    I want to scale my directory site, So please answer this question fast.

    • This reply was modified 1 year, 8 months ago by arasu.
Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Is it your plugin suitable for big website?’ is closed to new replies.