Hi all, I've been wrestling with working with a 2Gb table on my shared hosting for some time. I've optimized said tabl as best as I can, removed unecessary fields, optimized queries, added indexes etc. Some queries run quite nice and quick. But some do not, and my database guru guy tells me this is likely due to the large number of rows I am trying to group together and do computations on. Given this I'm looking at maybe getting a dedicated server for the database. So - what server setup should I be looking for and how much might it cost me? The database table to query is around 2.5Gb with data + indexes and lets say I need to (at max, at present) run a query which groups a million rows together (that's probably an overstatement). I guess what I want is a server with enough ram to hold the whole database in memory for sub-second queries? Database table grows by around 100K records each day. Cheers everyone Mike
You should get a new server only if you're sure you can't do anything anymore to optimize your database. Post your query, table structure... There's probably something you can do to make it work faster.
Hmmm. shared hosting? I'm surprised you haven't been asked to move on yet, trying to use that sort of size table. That's a _lot_ of computational power you'll need there, and a pretty big chunk or RAM to avoid swapping. If you expect that magnitude of query to run sub-second, you're looking at a high end dual or quad processor machine with at least 4Gig ram.
I think you need to tune your sqls better. If your query is bad, you won't see that great of a performance increase even on the faster server. Post one of your slow queries.