Ponder over a problem: On the foundation that how implementation retrieves in first time to undertake 2 times retrieval?
Normally, our practice is save when first time retrieval retrieve a condition, when retrieving the 2nd times all right combination retrieves a condition twice to have new inquiry to the database, be like:
First time retrieval: Select * From Table Where Age>18
Retrieve the 2nd times: Select * From Table Where Age>18 And Name Like ‘zh%’
Although can achieve the result that we want such doing, but the individual on efficiency thought to call a discount greatly however!
Can the record volume that cache first time retrieves, when retrieving the 2nd times, be in only the record of cache undertakes on collect, is new undertake inquiring to the database?
RecordSet object has an attribute Filter, its action is the record volume that is about to show with control through adding a requirement, but do not affect originally record volume! Fall how to come true 2 times to retrieve with it in light of us:
|
It is quotative content below: Response.Write ” retrieves: Select * From T1 Where Age>20<br/> "
Response.Write ” retrieves 2 times: King of Filter(name Like ‘ %’)<br/> " Ors.Close
|
Result:
In all 2 pages: On one page 1[2] Issue one page
