--- In IBObjects@y..., Helen Borrie <helebor@t...> wrote:

> At 01:55 AM 29-11-02 +0000, you wrote:
>
>
> No. But if you are forcing a prepare to occur every time the same

query is

> run, you are adding that overhead every time. Refer back to my

comments on

> this subject about 3 messages agol

Thanks! I understand that.

> Your monitor figures are very revealing. They show that it is not

the

> client nor the server which is causing the slowness, but your

network.

>
> These kind of figures are what I observe when querying from a

client across

> the web.
>
> So just how remote is "remote"?
>
> What is your remote protocol?
>
> What else is your physical network doing?
>

Yes, the remote is accessing the server through the internet using
TCP/IP. I know the performance is not guaranteed, and sometimes it is
absolutely normal to be slow. Why I raise this question is becuase I
came from MySQL+ZeosLib, their remote performance is obviously more
acceptable than what I am getting now, *under than same network
condition*. Of course they are no match for Interbase+IBO in terms of
features and ease of UI building, that's why I leave them to come to
IBO. If I can make response look faster, I will switch most of my
development to IBO.

Rgds,
Michael

PS. *under the same network condition* means at the same time of day,
tried 20~30 times, take the average of them.