Opinion On Website Statistics

[golfinggod]

Hi
I am in need of some opinions, I am looking to develop a site that specialises in website statistics and tracking. I am a bit unsure though about database size. I want to host website stats, does anyone know what sort of capacity a mysql database can hold before it really starts to slow down.

Thanks All

[vaaaska]

I recall hearing a few times 10,000...but I'm sure somebody will have a different number.

[bubblenut]

10,000 what? If you mean rows then it would completely depend on the size of the row. At work our orderline table has over 16million rows atm. It's pretty damned quick so long you use one of the indexed fields otherwise it can get a little sticky. A couple of days ago I found a query lurking on one of the reporting db machines which had been running for almost 36 hours! I killed it, if there was anyone waiting for that I feel sorry for them but I haven't heard anything back yet.

[Bunkermaster]

It all depends if you have any idea how to optimized a well designed database queried through really intelligent SQL. The said database being hosted on a box tuned for it with the assets required to do what you ask of it.

Simple really, isn't it?