Re: [PHP-DB] maximum number of records in a db?

2005-08-26 Thread Miles Thompson
At 12:11 PM 8/26/2005, Jordan Miller wrote: I was just wondering what is the maximum number of records that can be successfully handled with a db. any db will do. it doesn't have to be the fastest or best, just one that can hold the maximum number of records and still be able to interact well

Re: [PHP-DB] maximum number of records in a db?

2005-08-26 Thread Jordan Miller
i am talking about individual records, not putting all records into a very long string, if that's what you are saying. i know people routinely use millions of records... but how about billions or more? Jordan On Aug 26, 2005, at 10:29 AM, Miles Thompson wrote: At 12:11 PM 8/26/2005,

Re: [PHP-DB] maximum number of records in a db?

2005-08-26 Thread Raz
Perhaps you misunderstood what Miles wrote...never mind eh? Go here for example: http://www.mysql.com/why-mysql/ - found that in about 6 secs... raz -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] maximum number of records in a db?

2005-08-26 Thread Bastien Koert
like i said, billions are possible, but it becomes more of hardware issue, disk space, network availability etc bastien From: Jordan Miller [EMAIL PROTECTED] To: Miles Thompson [EMAIL PROTECTED] CC: php-db@lists.php.net Subject: Re: [PHP-DB] maximum number of records in a db? Date: Fri, 26

RE: [PHP-DB] maximum number of records in a db?

2005-08-26 Thread Bastien Koert
It kinda depends on the load placed on the db. Large chunks of data in the db (like images or other files like video, pdf etc) can slow the system down. There are many databases running with over 50Million rows of data in a table. But at a certain level, its as much hardware and network