Re: Mysql 5.0 ARCHIVE and auto_increment question.
Posted by:
Jay Pike
Date: December 23, 2005 04:09PM
I can see the argument towards the indexed field for the autoincrement... makes it easier to determine the next value if the field is already in memory... I like the fake-it idea, for Archive tables.
What am I doing with the ARCHIVE table? I'm storing accounting records for 300k subscribers' RADIUS records. A perfect implementation of ARCHIVE, IMHO: only inserts and the ocassional read. No updates, modifies, or deletes. So, I figured why waste the disk space on regular old MyISAM tables, and try ARCHIVE.
jp
Subject
Views
Written By
Posted
11792
December 23, 2005 01:33PM
4695
December 23, 2005 02:09PM
Re: Mysql 5.0 ARCHIVE and auto_increment question.
4489
December 23, 2005 04:09PM
4249
December 23, 2005 04:11PM
4237
December 25, 2005 12:25PM
4115
January 10, 2006 03:30PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.