Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: Web
Expertise: Advanced
Dec 15, 2001

Limit Data Connection through Fast Retrieval of Recordsets


One of the most overlooked and underused methods of the ADO object is GetRows(). This will quickly retrieve your recordset as a bi-dimensional array in the form of Array(columns,rows). While you still have to use nested loops to build your HTML table (which is conceptually the same as working with a recordset using Do While NOT recordset.EOF - Loop scenario) you will have greatly reduced the data access time (critical in busy dynamic Web applications) and improved your overall application speed.
Alex Radu
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date