Paging Records With GetRows
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!
Classifieds Theme (New 2022) - Download Now!Sponsored
Inout RealEstate - Map Based Advanced Real Estate PortalSponsored
Cloudflare Ongoing Management & Monitoring (Monthly)
Monthly Cloudflare management including policy changes, monitoring, tuning and issue response.
Overall cost optimisation by monitoring AWS Cost Explorer
Analyse AWS costs using Cost Explorer and suggest practical ways to reduce monthly bills.
Automating AWS Server Backups and configuring AWS Backup Cycles and AWS Backup rules
Set up automated backups for AWS servers using AWS Backup and clear backup cycles.
Help/Fix on AWS VPC General/Advanced Services (1 Hour)
One hour of help or fixes for AWS VPC networking issues or advanced configurations.