anyone? are these time normal or indicate some problem? my query is a simple select * from...
--- In [email protected], "cruvadom" <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 > Avg fetch time = 54.50 ms > Current memory = 34,262,768 > Max memory = 34,553,872 > Memory buffers = 2,048 > Reads from disk to cache = 0 > Writes from cache to disk = 0 > Fetches from cache = 13 > > > My settings: > Firebird SuperServer 2.5 (on win xp sp2) > Latest IBExpert on client side. (win7) > No firewall > ping from client to server is around 190 ms. > server can't reach client with ping (weird, but I don't think matters) > added client to server hosts file and vice versa. > Disabled system restore on server (read it somewhere) >
