Take the 2-minute tour ×
WordPress Development Stack Exchange is a question and answer site for WordPress developers and administrators. It's 100% free, no registration required.

I am in process of setting up a catalog website and it has some 1.5 Lac products. I will write some script to import all the products but I am not sure whether WordPress will be able to handle such a large amount of posts.

Have any one imported so many posts in WordPress and how much is the degrade in the performance of the website. And any solutions to fix that performance.

Can any one suggest any other CMS or framework to handle such a large data?

share|improve this question
1  
Sorry but what is a Lac? Thousand? –  GhostToast May 7 '13 at 17:43
    
Maybe Lakh? –  toscho May 7 '13 at 17:47
    
Yeah, Lac is Lakh (100 thousand). –  Lalit Arora May 7 '13 at 18:12

1 Answer 1

The performance of WordPress does not depend on the number of posts. It depends on the server performance (how fast can PHP scripts be executed). And the performance of the MySQL Server.

The server performance is normally no problem if you got enough memory. The bottleneck is in most cases the MySQL server and the connection to it. Sometimes a misconfigured MySQL server can slow down your database queries. MySQL is made to handle very large databases, it makes no difference if there are 15 or 15 million posts. wordpress.com is made with WordPress and there are definitivly a lot of post to handle.

But this is all out of scope of this page, it has nothing to do with WordPress.

WordPress itself cann be slowed down by bad written plugins and themes. Such who make a lot of (senseless) database queries. There is no other way then uninstall problematic plugins and/or themes and use better ones.

I will write some script to import all the products

It depends on which language you use for your script. PHP is not the first choice for such a job. A MySQL script would be the better choice and can do the job much faster.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.