By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,086 Members | 1,442 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,086 IT Pros & Developers. It's quick & easy.

Client Side Cursor vs Sever Side Cursor?

P: n/a
Jim
I having a difficult time here trying to figure out what to do here.
I need a way to scroll through a recordset and display the results
with both forward and backward movement on a web page(PHP using
ADO/COM)..

I know that if I use a client side cursor all the records get shoved
to the client everytime that stored procedure is executed..if this
database grows big wont that be an issue?..

I know that I can set up a server side cursor that will only send the
record I need to the front end but..

Ive been reading around and a lot of people have been saying never to
use a server side cursor because of peformance issues.

So i guess im weighing network performance needs with the client side
cursor vs server performance with the server side cursor..I am really
confused..which one should I use?

-Jim
Jul 20 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Jim:
I having a difficult time here trying to figure out what to do here.
I need a way to scroll through a recordset and display the results
with both forward and backward movement on a web page(PHP using
ADO/COM)..
Not sure why you would need anything else other than a forward only
recordset on a website. Unless you are planning on persisting the recordset
for the session and then navigating back and forth thru it.
I know that if I use a client side cursor all the records get shoved
to the client everytime that stored procedure is executed..if this
database grows big wont that be an issue?..
Please note that your "Client" in this case would be the web server and not
the actual end users browser.
Ive been reading around and a lot of people have been saying never to
use a server side cursor because of peformance issues.
Does your web server (IIS or Apache) reside on the same physical server as
the database?. I would think that the performance issues would come from the
network trip hit. But if the web server and database are on the same
physical server, then this wouldn't matter.

Personally, I don't like the idea of returning 1,000,000 records just to
display 20 at a time. Nor do I think you can keep a connection/recordset
alive in between web pages without severaly affecting scalability.

You may want to do a search on this newsgroup thru google groups for other
paging techniques that will return only the results the user needs.

HTH,

BZ

"Jim" <ji********@motorola.com> wrote in message
news:72**************************@posting.google.c om... I having a difficult time here trying to figure out what to do here.
I need a way to scroll through a recordset and display the results
with both forward and backward movement on a web page(PHP using
ADO/COM)..

I know that if I use a client side cursor all the records get shoved
to the client everytime that stored procedure is executed..if this
database grows big wont that be an issue?..

I know that I can set up a server side cursor that will only send the
record I need to the front end but..

Ive been reading around and a lot of people have been saying never to
use a server side cursor because of peformance issues.

So i guess im weighing network performance needs with the client side
cursor vs server performance with the server side cursor..I am really
confused..which one should I use?

-Jim

Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.