|
|
Home » ASP Home » SQL Home » Table Database Display via GetRows
A D V E R T I S E M E N T
| Title |
Table Database Display via GetRows |
| Description |
This page demonstrates the capabilities how to display a table from a SQL statement a very fast and scaleable way using a recordset method called GetRows. GetRows that move many records and fields into a memory array. Once in the array it is accessed very fast. If you read the code closely you will notice it can free up the recordset and connection object earlier than the traditional loop thus freeing up those resources for other scripts. The array fields are accessed by number, a script at: http://www.learnasp.com/learn/dbtablegetrowsnamed.asp shows how to combine the speed of getrows and simulate named fields using dictionary objects. In terms of why this is faster and reduces server resource consumption, read: http://www.learnasp.com/advice/whygetrows.asp to see an in-depth explanation. http://www.learnasp.com/learn/dbtablegetstring.asp rips getrows to shreds speed-wise as the backend transfers one big string instead of a complex array structure but formatting is SOOOOO limited (unless you know Regexps like the back of your hand....) |
| Category |
ASP » SQL |
| Hits |
382515 |
| Code |
Select and Copy the Code
|
|
|
Related Source Codes
A D V E R T I S E M E N T
|
Subscribe to SourceCodesWorld - Techies Talk |
New! Click here to Add your Code!
ASP Home | C Home | C++ Home | COBOL Home | Java Home | Pascal Home
Source Codes Home Page | |
|
Add to Favorites
Make Home Page
