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

Tue, 31 January 2012 03:36

Michael Fesser
Messages: 215
Registered: September 2010

Karma:

Senior Member

.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

--
http://mfesser.de/blickwinkel

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: Mon Nov 25 03:00:56 GMT 2024

Total time taken to generate the page: 0.04223 seconds