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)
