--- In firebird-support@yahoogroups.com, "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