Re: [OT]Efficiency questions on MySQL

I'll try to answer these in order.

It depends. How many is "lots"? How slow is "slow"?
It depends. What do you mean by "suffer"? Do you need those millions of rows? How are your indexes? What does the query plan look like?
It depends. How does the query plan look? Are you joining the tables on primary keys, or at least indexed columns?

Now I have one question for you. Have you found your application to be too slow, profiled it, and noticed that after tuning MySQL appropriately and normalizing your tables, it's still too slow?

Comment on Re: [OT]Efficiency questions on MySQL

Replies are listed 'Best First'.

Re^2: [OT]Efficiency questions on MySQL
by kiat (Vicar) on Aug 18, 2004 at 05:48 UTC

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.

[reply]

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]