Just a hint... Have you tested passing parameter? Select *... where cc.id = @id_par
Regards, Paul > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf > Of Sylvain > Sent: Friday, February 16, 2007 1:27 PM > To: [email protected] > Subject: [Firebird-net-provider] Big performance issue > > Hi, > > Can you explain me why I've got a performance problem with this query : > > select * from finventr i > join fcontact_client cc on cc.codeclient = i.codeclient > where cc.id = '24' > > > I tested it with this code : > > FbConnection cnx = new FbConnection(@"Server=localhost..."); > cnx.Open(); > Console.WriteLine(DateTime.Now.ToLongTimeString() +" Before"); > DataTable dt = new DataTable(); > FbDataAdapter da = new FbDataAdapter("select * from finventr ...", > cnx); > da.Fill(dt); > Console.WriteLine(DateTime.Now.ToLongTimeString() + " After"); > > > It took about 20 seconds. > > > If I execute the same query with IBExpert (with "Execute and Fetch all" > option), it took less than 2 seconds ! > > How this can be explained ? > > ----------------------------------------------------------------------- > -- > 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=DEVD > EV > _______________________________________________ > Firebird-net-provider mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider ------------------------------------------------------------------------- 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 [email protected] https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
