Re: [policyd-users] Database optimization

2007-02-18 Thread Cami
J Sloan wrote: > > Cami wrote: >> Oliver Eales wrote: >> >>> Hugo Monteiro schrieb: >>> Hello all, i've noticed that there aren't any indexes defined whatsoever, besides the ones automatically created for keys. Couldn't there be some indexes to speed up the queries

Re: [policyd-users] Database optimization

2007-02-16 Thread J Sloan
Cami wrote: > Oliver Eales wrote: > >> Hugo Monteiro schrieb: >> >>> Hello all, >>> >>> i've noticed that there aren't any indexes defined whatsoever, besides >>> the ones automatically created for keys. Couldn't there be some indexes >>> to speed up the queries? >>> >>> >> The

Re: [policyd-users] Database optimization

2007-02-16 Thread Leonardo Rodrigues Magalhães
Cami escreveu: > Hugo Monteiro wrote: > >> Hello all, >> >> i've noticed that there aren't any indexes defined whatsoever, besides >> the ones automatically created for keys. >> > > That is false information. Please provide proof. > Yeah . last time i checked, the few indexes

Re: [policyd-users] Database optimization

2007-02-16 Thread Cami
Oliver Eales wrote: > Hugo Monteiro schrieb: >> Hello all, >> >> i've noticed that there aren't any indexes defined whatsoever, besides >> the ones automatically created for keys. Couldn't there be some indexes >> to speed up the queries? >> > The database layout is fine. > I got the most improv

Re: [policyd-users] Database optimization

2007-02-16 Thread Oliver Eales
Hugo Monteiro schrieb: > Hello all, > > i've noticed that there aren't any indexes defined whatsoever, besides > the ones automatically created for keys. Couldn't there be some indexes > to speed up the queries? > The database layout is fine. I got the most improvement from using InnoDB as MySql

Re: [policyd-users] Database optimization

2007-02-15 Thread Cami
Hugo Monteiro wrote: > Hello all, > > i've noticed that there aren't any indexes defined whatsoever, besides > the ones automatically created for keys. That is false information. Please provide proof. > Couldn't there be some indexes to speed up the queries? There are indexes. > One other thin

[policyd-users] Database optimization

2007-02-15 Thread Hugo Monteiro
Hello all, i've noticed that there aren't any indexes defined whatsoever, besides the ones automatically created for keys. Couldn't there be some indexes to speed up the queries? One other thing i'd like to know is if there are any plans, or if anyone knows of any work in progress for a frontend