Hi,

I am currently using the program Esvon Classifieds www .esvon.com/pg/products/p_classifieds/features/ to running my business.

There are 1000 categories /sub-categoies and around 100,000 ads in one database now. We believed that our ads will over one million within coming few years. Besides, without any noticeable performance loss at this moment.

(1) Any problem if running over one million ads in one database?

(2) What is the problem in the server side if running a huge database?

(3) If you am I, what will you do and how to planning at this moment?

Thanks
GAry

MySQL can handle 1,000,000 lines in the database no problem, it will come down to coding of the software and the setup of the database servers. Depending on how the software is written, how much it is used, how the database is structured (i've seen some applications that have horrid database design, the term normalization must never have been mentioned to the creators) there are quite a few options that you can go with.

The first step will most likely to be splitting up the front-end and the database onto two seperate machines. Put that database on a beefy machines ;)

If that is not enough you're going to have two options. You can either get into database replication (I suggest master to master clustering with MySQL) or you could look at splitting the database between several servers (would require rewiting the software at least a little bit).

Odds are that just having the database on a nice beefy machine all by itself will be enough, but I have no experience with that piece of software.