Hello, bear007 said the following on 13.12.2006 8:26:
I'd add read-only transaction options to the code in order to lower server's load: > FbCommand cmd = new FbCommand(); > cmd.CommandText = "Select * from Table where POSTAL_CODE = 84652"; > cmd.Connection = conn; cmd.Transaction = conn.BeginTransaction(FbTransactionOptions.Read | FbTransactionOptions.ReadCommitted); > FbDataAdapter da = new FbDataAdapter(cmd); > da.Fill(dt); cmd.Transaction.Commit(); > It can be so long, but a program called "IBEasy+" gets the same result > with the same Query in about, i don't know... a small part of one second :) I don't know how is it in IBEasy+, but in the IBExpert there is button "Execute and fetch all records" - you sould try this and compare. -- Oleg ------------------------------------------------------------------------- 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
