FUDforum: comp.lang.php » php DB rotation

Home » Imported messages » comp.lang.php » php DB rotation

Show: Today's Messages :: Polls :: Message Navigator

Re: php DB rotation [message #176878 is a reply to message #176876]

Tue, 31 January 2012 08:38

M. Strobel
Messages: 386
Registered: December 2011

Karma:

Senior Member

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.

Report message to a moderator

[Message index]

		php DB rotation By: Jim Lee on Tue, 31 January 2012 02:05
		Re: php DB rotation By: Michael Fesser on Tue, 31 January 2012 03:36
		Re: php DB rotation By: Jim Lee on Tue, 31 January 2012 04:03
		Re: php DB rotation By: Captain Paralytic on Tue, 31 January 2012 10:25
		Re: php DB rotation By: The Natural Philosoph on Tue, 31 January 2012 14:00
		Re: php DB rotation By: M. Strobel on Tue, 31 January 2012 08:38
		Re: php DB rotation By: Denis McMahon on Tue, 31 January 2012 09:23
		Re: php DB rotation By: Chris Riesbeck on Tue, 31 January 2012 19:00

Previous Topic:	Freelance PHP Developer
Next Topic:	enter search term via code?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Nov 27 11:48:38 GMT 2024

Total time taken to generate the page: 0.04823 seconds