Re^2: [OT]Efficiency questions on MySQL

Thanks, chromatic!

I haven't done any of those - things such as profiling and tuning.

I have been adding more and more tables to the same database and those questions came to mind.

Comment on Re^2: [OT]Efficiency questions on MySQL

Replies are listed 'Best First'.

Re^3: [OT]Efficiency questions on MySQL
by chromatic (Archbishop) on Aug 18, 2004 at 06:19 UTC

The MySQL developers run a couple of large databases (millions of rows). At work, we run a couple of complex databases (several dozen tables). I expect that with tuning and decent hardware, the upper limits are in the billions of rows, hundreds of tables, and multi-gigabytes of data.

If this is all one system and if the data belongs in the database, put it there. Keep an eye on performance and profile when you must, but otherwise, you should be okay.

[reply]

Re^4: [OT]Efficiency questions on MySQL

by PodMaster (Abbot) on Aug 18, 2004 at 06:44 UTC

MJD says "you can't just make shit up and expect the computer to know what you mean, retardo!"
I run a Win32 PPM repository for perl 5.6.x and 5.8.x -- I take requests (README).
** The third rule of perl club is a statement of fact: pod is sexy.

[reply]