[archangel]

I have a database that contains tables with a lot of entries in each. My question is, how many entries is too many before the server (P4, 2.4 Ghz, 1 mb ram) starts to lag or come to a crawl?

If I have 1 million + entries each in 15 - 25 different tables... and it's contantly being inserted to, updating entries, and deleting entries... do you think my machine would be able to handle it? .... assuming that the server is solely dedicated for MySQL and not any other stuff, such as Apache, etc.

If it can't handle this much, which databases would be better equipped to handle it? ... or would a faster, beefier server solve the problem?

Thanks....

[kvnband]

I'd say that it all depends on the frequency of the queries. If you're getting 1 or 2 queries an hour, then sure it can handle it. But if your site is popular, like Webhostingtalk, or something similar, then you're going to probably want to look into load balancing across several servers. I'd say though that you're probably pretty safe right now.

(course I could be wrong

[Infinite_Hackers]

A dedicated server for mysql would be fine, but if it's very popular you would need to do what kvnband says, but ims ure it's fine

[mousegu]

As far as servers, I don't know. But MySQL will have no problem. MySQL supports more than 50,000,000 rows and 8 million terabytes per table. So that's plenty. It's now just a server question... unless that's all it was to begin with? Sorry but it's really late and I'm lost.