Re: Using Cursors
| From: | Robert Twitty | Date: | Tue, 01 Jun 2004 15:30:02 +0000 |
| Subject: | Re: Using Cursors | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-34618@lists.php.net to get a copy of this message | ||
Hi
I am not aware of a website that talks about cursors. However, I do know
that they should be avoided whenever possible. They tend to require a lot
of resources. I mostly use them in stored procedures when I need to loop
through a result set. If you like, I can provide you with MS SQL Server
syntax. Cursors historically are used for grid-based application, and not
web-based applications. What are you doing that requires the use of a
cursor?
-- bob
On Tue, 1 Jun 2004, Gerard Samuel wrote:
> A bit off topic, but lately I've been running into situations, where I have
> to know about using cursors with databases, like sql server, ibm db2....
> Can anyone point me to online resources that explains (to a practical newbie)
> "cursors"
>
> Thanks
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>