--- In [email protected], "cruvadom" wrote: > > Hi all, > I have a IBExpert client querying Firebird 2.5 server via tcp/ip over WAN. > I'm making a simple query on the client side for an indexed table containing > 2 columns and 4 rows (very small). > overall time until data is shown is around 10 seconds. > Prepare time is around 3 sec, execution is around 200 ms. > same query locally (client on the same machine as server) takes 1 ms to > process. > is it normal? I think too slow. any ideas? > > Thanks, > Gil. > > IBExpert data about the query: > Plan > PLAN (AmazonCategories NATURAL) > > ------ Performance info ------ > Prepare time = 2s 839ms > Execute time = 218ms
IBE is *very* ineficient application on slow lines. Try isql. > My settings: > Firebird SuperServer 2.5 (on win xp sp2) > Latest IBExpert on client side. (win7) Make sure you have fbclient v2.1 at least. > No firewall > ping from client to server is around 190 ms. This is well correlated with execution time (218 ms). > server can't reach client with ping (weird, but I don't think matters) Yes, it doesn't matters. With roundtrip time 190 ms you can't expect fast response not from Firebird, nor from any other client-server system which makes many roundtrips. Regards, Vlad
