Browse DevX
Sign up for e-mail newsletters from DevX

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



Building the Right Environment to Support AI, Machine Learning and Deep Learning

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.



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