Re: anthill mysql postgres performance

Russell Valentine <russ-98fVsw/2eqlQihsdzhub5di2O/[email protected]> Wed, 3 Dec 2003 19:36:33 -0600
Newsgroups gmane.comp.bug-tracking.anthill.devel
Organization Coldstone Labs
Message-ID <[email protected]>
On Sun, 30 Nov 2003 20:25:04 -0700
Vincent Danen <[email protected]> wrote:

> 
> Ok, so my initial gut feeling was somewhat correct then.  I do have 
> some optimizations in the postgres side (creating the indexes), but 
> don't know if there is something comparable on the mysql side that I 
> can do as well.


What about MySQL indexes?
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#CREATE_INDEX

Althouth I wouldn't think indexes make that much of a difference when
there isn't very much data in there. Atleast that is the way it works in
databases like PostgreSQL and Oracle.


Russell Valentine

_______________________________________________
Anthill-workers mailing list
Anthill-workers-+mQDA36h6dWw5LPnMra/[email protected]
http://vmlinuz.ca/mailman/listinfo/anthill-workers
signature.asc (application/pgp-signature, 189 B)
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.3 (GNU/Linux)

iD8DBQE/zo+lO0EDJO5MgRYRAnC9AJ9EnERPa+KlefVGT1F/uQ6mvMaOawCfSssd
hV6WMReUjszJh+uX4jBwcv8=
=kIUD
-----END PGP SIGNATURE-----