Want to hire a development team?
No Images Added Yet

Paging Records With GetRows

Not Rated Yet.
Add to Favorites
Publisher
Teaches you the alternative solution to paging records.
Product Details

You all must have seen and done stuff with the RecordSet object, infact everything is done with the RecordSet object. Now, this acticle explains how to use GetRows to page through the records that you recieve from the SELECT. It's much faster than MoveNext, because it closes the database connection immediately whereas MoveNext loops through the records with the overhead of the database connection. Plus GetRows let's you count the records correctly!

Report this Listing
Price
Free
Licence Type
Free
Views
4,345
Submitted on
1st October 2000
Last Updated
4th October 2003

You May Also Like

Cloud Services You May Like

Create CloudWatch Alarms and Automated Performance-Based Actions

Setting up CloudWatch alarms to monitor server performance and trigger automated actions based on customized conditions.

Cost optimization by archiving standard AWS snapshots

Reduce storage costs by cleaning up and archiving old EC2 or EBS snapshots safely.

AWS Aurora DB configurations

Set up or tune Amazon Aurora for high performance and high availability workloads.

Help/Fix on AWS Auto Scaling (1 Hour)

One hour of help to troubleshoot or fine tune AWS Auto Scaling behaviour.

User Reviews

Please rate the listing and tell the world know what do you think about the listing.
(0 ratings)
Not Rated Yet.
No reviews found.
Not yet reviewed by any member. You can be the first one to write a review for this listing.Click hereto submit your review.