Jiri Cincura a exposé le 28/11/2006 : > Hi, > > in this method is SELECT COUNT(*), which isn't good. You should better use > exists. > > The count have to go through all table and count, but exists predicate will > stop when the first match is found - and it's much faster. > > Will you fix this Leroy or should I do it?
OK jiri i will fix that with the others changes ------------------------------------------------------------------------- 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 _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
