PHP DB - RE: [PHP-DB] Moving data from one MySQL table to another

Author

RE: [PHP-DB] Moving data from one MySQL table to another

Bastien Koert

2005-05-19, 3:56 pm

if the archive tables structures are identical and no processing needs to be
done, why not use a 'select into table where ' and use the ids of the
records to choose the ones that move?

Bastien

>From: Jeffrey <jeffreyb@ungodly.com>
>To: php-db@lists.php.net
>Subject: [PHP-DB] Moving data from one MySQL table to another
>Date: Thu, 19 May 2005 15:19:48 +0200
>
>I'm working on a web application and one of the things I am doing is
>creating an archiving function that would move older data to archive tables
>in order to minimise the amount of data in the active tables. This so that
>the data that is being used more frequently can be accessed faster by the
>users.
>
>My approach in building the archive function is:
>
>1) SELECT query on the data
>2) mysql_fetch_array to put the data into an array
>3) INSERT subqueries to put the data into the archive tables.
>
>My concern is that in some cases, hundreds of rows of data would need to be
>moved - which could lead to awfully big arrays. However, the archiving
>function is likely to be used infrequently - not more than 1 or 2 times per
>w

.
>
>This leads to two questions:
>
>1) Could such a big array cause performance problems or worse?
>2) Is there a better way?
>
>Many thanks,
>
>Jeff
>
>--
>PHP Database Mailing List (http://www.php.net/)
>To unsubscribe, visit: http://www.php.net/unsub.php
>

Luis Morales

2005-05-19, 3:56 pm

Try do that whit phpmyadmin.

Regards,

Luis Morales

Bastien Koert wrote:

> if the archive tables structures are identical and no processing needs
> to be done, why not use a 'select into table where ' and use the ids
> of the records to choose the ones that move?
>
> Bastien
>
>

Sponsored Links