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=DEVDEV
_______________________________________________
Firebird-net-provider mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
