> 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
another simple test would be to connect via ISQL (it comes with Firebird), and issue the same command. Count the time it takes to feed the records past the console. It'll take a lot longer than you ever imagine. Alan ------------------------------------------------------------------------- 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
