Re: index on created table

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-7qY7E20V6GW73k+5HYS8LQqVMODqnSLI@public.gmane.org
-- 
Edward Rudd <[email protected]>
Website http://www.outoforder.cc/

_______________________________________________
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-7qY7E20V6GW73k+5HYS8LQqVMODqnSLI@public.gmane.org

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.3 (GNU/Linux)

iD8DBQBCWUBhvwMxRUUct20RAv3OAJwIOiMUKCYC4mJ+IAuuogRI3ag4+gCdFDTk
RvEwUuGzUQ0apUqa/wG4I8s=
=SfW/
-----END PGP SIGNATURE-----