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

Tue, 31 January 2012 14:00

The Natural Philosoph
Messages: 993
Registered: September 2010

Karma:

Senior Member

Jim Lee wrote:
> 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.

That you can do by simply tying the server in to ntp.

or you might be able to do an NTP call to the 'net directly..if it fails
I guess you use the old server name.

My machines do record reasonably weird ties at boot..I suppose they
start off the realtime clock - but that changes pretty quickly.

IIRC you CAN use ntp to update the realtime clocks on most hardware..so
as to minimise the difference.

http://linux.die.net/man/8/hwclock

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: Fri Sep 20 00:50:04 GMT 2024

Total time taken to generate the page: 0.04691 seconds