[Mod_log_sql] index on created table
urkle at outoforder.cc
Sun Apr 10 10:04:02 EST 2005
On Sun, 2005-04-10 at 08:43, Derk Gortemaker wrote:
> I'm wondering why no primary index is created on the access tables that are
> created automaticaly. Is is because is takes space and time to create and
> keep them?
hmm. Honestly I don't know. The previous 3 authors of mod_log_sql never
added an primary key, but I do see the need for one as w/o it you can
not easily select unique records. If you would like you can just add a
primary key (probably of type big int unsigned auto_increment) and see
if it slows anything down, there is no need to modify mod_log_sql at all
if you make it an auto_increment field.
Let me know if it affects performance badly.. if it doesn't than I'll
make that change for the next release.
> Derk Gortemaker
> Download the latest version at http://www.outoforder.cc/projects/apache/mod_log_sql/
> To unsubscribe send an e-mail to
mod_log_sql-unsubscribe at lists.outoforder.cc
Edward Rudd <urkle at outoforder.cc>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Size: 189 bytes
Desc: This is a digitally signed message part
Url : http://lists.outoforder.cc/pipermail/mod_log_sql/attachments/20050410/94bc75b8/attachment.bin
More information about the Mod_log_sql