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 storage engine instead of Myisam, as Myisam has the problem of locking whole tables.
You just have to replace the INSERT DELAYED statements with simple INSERT. Regards, Oliver ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys-and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ policyd-users mailing list policyd-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/policyd-users