anyone? are these time normal or indicate some problem? my query is a simple select * from...

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