Yes indeed, as Jimmy says, having a database for each site is impractical and a waste of resources.
On 27 October 2010 11:23, Jimmy Sole <jimmys...@gmail.com> wrote: > In my opinion, having a database for each site would require a lot of > unnecessary work, as you would have to connect to every database in order to > handle the sites. > Having one database with tables for all the sites would be more productive as > you would not have to change the connection info for PHP every time you want > to use a different database. > I use the PDO mysql adapter, what do you use? > > -----Original Message----- > From: Andrés G. Montañez [mailto:andresmonta...@gmail.com] > Sent: Wednesday, October 27, 2010 9:19 AM > To: Ethan Rosenberg > Cc: php-db-lists.php.net > Subject: Re: [PHP-DB] Incrementing Primary Key > > Hi Ethan, > in this case, you should manage the "keys" by your application, and store the > used ids in aonther table, similar to a "sequence" in Oracle or Postgresql. > Thats so if you want all the records un one table (a field for the letter, > and the other for the numeric part). > > Otherwise, having a table for each site will be enough, as Jimmy suggests. > > -- > Andrés G. Montañez > Zend Certified Engineer > Montevideo - Uruguay > > -- > PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: > http://www.php.net/unsub.php > > > -- Andrés G. Montañez Zend Certified Engineer Montevideo - Uruguay -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php