14.12.2011 20:02, Carlos H. Cantu wrote: > Vlad, 06/12/2010 16:24:51: > could you edit firebird.conf at both client and server hosts and set > TcpRemoteBufferSize = 32700 > ? > > ok, much better (but still worse than MySQL): > [06/12/2010 16:27:47] Opening FB Query and fetching all data () > [06/12/2010 16:27:53] End fetching FB data (6,312) > [06/12/2010 16:27:53] Opening MySQL Query and fetching all data () > [06/12/2010 16:27:56] End fetching MySQL data (2,89)
This implicitly suggests that a bigger value of the network packet could improve the performance even more, perhaps down to the MySQL's almost three seconds. AFAIK, the default packet size in MySQL is 1MB, the maximum is 1GB. Our default is 8KB and maximum is 16KB. I would suggest to increase the default and remove the upper limit (or make it "big enough") and then ask Carlos to re-run the same test with bigger settings (64KB, 128KB and so on) and report back the results. Dmitry ------------------------------------------------------------------------------ Cloud Computing - Latest Buzzword or a Glimpse of the Future? This paper surveys cloud computing today: What are the benefits? Why are businesses embracing it? What are its payoffs and pitfalls? http://www.accelacomm.com/jaw/sdnl/114/51425149/ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
