Re: anthill mysql postgres performance

On Dec 03, 2003, at 18:36, Russell Valentine 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.

Sorry about the slow response to this stuff... other things have  
cropped up and I had to put a bit of a halt on anthill development as I  
was too busy.  I'm aiming to spend the next few days to get this  
postgres stuff sorted out.

I'll take a look at the indexes soon... for right now, performance  
isn't my 100% goal (at least not for mysql).  I'd like to get the  
postgres stuff taken care of so that it's 100% and then when that's  
complete, look at some db-specific optimization and some general  
optimization (although for the latter, I think I've conquered a lot  
using a lot of specific SELECT statements rather than SELECT * type  
stuff.

---
MandrakeSoft Security; http://www.mandrakesecure.net/
Online Security Resource Book; http://linsec.ca/
"lynx -source http://linsec.ca/vdanen.asc | gpg --import"
{FE6F2AFD : 88D8 0D23 8D4B 3407 5BD7  66F9 2043 D0E5 FE6F 2AFD}

_______________________________________________
Anthill-workers mailing list
Anthill-workers-+mQDA36h6dWw5LPnMra/[email protected]
http://vmlinuz.ca/mailman/listinfo/anthill-workers