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)