Re: [PHP-DB] ROugh idea of speed

2002-11-09 Thread Thomas Lamy
Steve Vernon [mailto:steve;extremewattage.co.uk] wrote: Hiya, Just wondering what is the rough idea of speed of a server like this is holding a database with millions of records. I know its difficult, depends on the data stored etc. Its basically storing an index int and about

Re: [PHP-DB] ROugh idea of speed

2002-11-09 Thread Maxim Maletsky
;php.net] Sent: 08 November 2002 15:09 To: Steve Vernon Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] ROugh idea of speed Steve Vernon [EMAIL PROTECTED] wrote... : Hiya, Just wondering what is the rough idea of speed of a server like this is holding a database with millions

Re: [PHP-DB] ROugh idea of speed

2002-11-08 Thread Maxim Maletsky
Steve Vernon [EMAIL PROTECTED] wrote... : Hiya, Just wondering what is the rough idea of speed of a server like this is holding a database with millions of records. I know its difficult, depends on the data stored etc. Also rather the design and, whether do you really need to store it

Re: [PHP-DB] ROugh idea of speed

2002-11-08 Thread Jason Wong
On Friday 08 November 2002 23:08, Maxim Maletsky wrote: Steve Vernon [EMAIL PROTECTED] wrote... : Hiya, Just wondering what is the rough idea of speed of a server like this is holding a database with millions of records. I know its difficult, depends on the data stored etc. Also

Re: [PHP-DB] ROugh idea of speed

2002-11-08 Thread Peter Beckman
I was running a site on a dual 800 CPU, 1GB ram, dual mirrored 18GB drives, doing about 16.8GB per day on average, including PHP/HTML code. The system had several tables (~20), some regularly accessed, some not. The biggest table was a log table of about 2.5+ million rows. Ran reports from it