Hello: > I tried setting FetchSize and PacketSize in connection string that probably > has no effect. PacketSize will have effect only when working against the standalone server. > I spent hours on googling for the solution, but the only thing that I found > is the fact that embedded server fetches each row separately and classic > one takes more so it doesn't waste time for communication. Yes, that is how it works, the embedded server support is implemented using PInvoke that has a performance penalty when doing the calls to the embedded server dll ( and selects that returns many rows will do a lot of calls )
-- Carlos Guzmán Álvarez Vigo-Spain ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Firebird-net-provider mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
