[VServer] OSX Problems

Erich Geiersberger erichg at mcmm.com
Fri Jan 30 20:40:49 CST 2004


>  > I am doing a getcolumn() on a table with 390 records.
>  > I have cached the list, it is about 76k large.
>
>  > If I use a server side cursor on the same machine, it lasts between
>  > 50.000 and 70.000 ms to do the getcolumn()
>
>  > If I use a client side cursor on the same machine it last between 
>2 and 3 ms.
>
>  > If I use a server side cursor on a Client (G4 400), it lasts about
>  > 700 ms to do the getcolumn()


>This have sense.
>
>Client side cursor get all in one step.
>
>Server side cursor run to server for each next record.

Hmm...
It takes one second to get the data from an OS 9 based (G4 400) 
machine over the network (other Xtra! not carbon).
It takes 50-70 seconds to get the same data on the SAME (G4 Dual, 
866) machine the database runs on (OSX, carbon Xtra).
Are you sure?

Erich



More information about the Valentina mailing list