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 #176877 is a reply to message #176876]

Tue, 31 January 2012 04:03

Jim Lee
Messages: 2
Registered: January 2012

Karma:

Junior Member

On Tue, 31 Jan 2012 04:36:37 +0100, Michael Fesser <netizen(at)gmx(dot)de>
wrote:

> .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

I must rotate to a new table, because there is another REST layer on
top of the DB, the REST call will have a new table-name every week to
read/write to.

my main problem now, is how to reliably compute the DB table-name?

using the server timestamp is a solution, I must make sure server time
is acurrant though.

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 13:39:19 GMT 2024

Total time taken to generate the page: 0.04140 seconds