[Mod_log_sql] index on created table

Edward Rudd urkle at outoforder.cc
Sun Apr 10 10:04:02 EST 2005

On Sun, 2005-04-10 at 08:43, Derk Gortemaker wrote:
> Hello,
> 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>
Website http://www.outoforder.cc/
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
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 mailing list