This site provides users with the information about asp, speed up large access database, how to speed up asp big access db, make access database run faster, use GetRows to speed up access db, and more.
If you think that this site is helpful, please recommend your friends to visit our site.
asp: how to speed up big access database?
Access database is the text-based database and not designed to process large quantities of data, but the following tips will surely make big differences:
1. Do not use db loop to find out records, use query with "where..."
2. Index related fields.
3. Add < % Option Explicit %> at the top of the page.
4. Add Response.Buffer = True at the top of the page and add Response.flush within each loop.
Besides the above four tips, you can also do the following:
1. Compact your database often.
2. Use GetRows()
aValues = rs.GetRows() 'get data in 2 dimentional array
'to retrieve data
For iRowLoop = 0 to UBound(aValues, 2)
For iColLoop = 0 to UBound(aValues, 1)
if(aValues(iColLoop, iRowLoop)<>"")then
if(iColLoop=0)then
out_value= aValues(iColLoop, iRowLoop)
exit for
end if
end if
Next
Next
|