Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.php > #4692

Re: php DB rotation

Show all headers | View raw

Am 31.01.2012 04:36, schrieb Michael Fesser:
> .oO(Jim Lee)
> 
>> I have a PHP server controller thatl read/write to Database table
>>
>> PHP server will start read / write to a new DB table every week/monday
>> e.g. 
>> table-1-2-2012
>> table-1-9-2012
>> table-1-16-2012
>> table-1-23-2012 ... etc
>>
>> I think of 2 ways to do the DB table rotation
> 
> The first question that comes to mind: Why table rotation? A good DBMS
> can easily handle millions of records, if properly indexed.
> 
> Or do you really have millions of new records each week? If not, just
> add a timestamp to your records and you can easily filter them by date.
> 
> Micha
> 

This subject cannot be discussed without knowing which database system is used on
which OS.

And then, go to the appropriate db group. I can tell that in the postgresql
performance groups "table partitioning" is a big subject.

/Str.

Back to comp.lang.php | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

php DB rotation Jim Lee <jimlee2907@yahoo.com> - 2012-01-30 18:05 -0800
  Re: php DB rotation Michael Fesser <netizen@gmx.de> - 2012-01-31 04:36 +0100
    Re: php DB rotation Jim Lee <jimlee2907@yahoo.com> - 2012-01-30 20:03 -0800
      Re: php DB rotation Captain Paralytic <paul_lautman@yahoo.com> - 2012-01-31 02:25 -0800
      Re: php DB rotation The Natural Philosopher <tnp@invalid.invalid> - 2012-01-31 14:00 +0000
    Re: php DB rotation "M. Strobel" <sorry_no_mail_here@nowhere.dee> - 2012-01-31 09:38 +0100
  Re: php DB rotation Denis McMahon <denismfmcmahon@gmail.com> - 2012-01-31 09:23 +0000
    Re: php DB rotation Chris Riesbeck <Chris.Riesbeck@gmail.com> - 2012-01-31 13:00 -0600

csiph-web