Client Side versus Server Side Cursors

[Ruslan Zasukhin]

On 5/5/06 6:08 PM, "Brandon" <bwarlick at sunbelt-graphics.com> wrote:

Hi Brandon,

> Our application displays a list of records from a table. The user can
> select one from the list and view it. Sometimes the list will have 10
> records. Other times the list will have 50,000 records. The user cannot
> add, edit or delete any records. The server is located in a separate
> city so we are limited to the speed of a broadband internet connection.
> 
> Should I use a client side cursor or a server side cursor when I run the
> sqlselect?

Server side of course

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]