<%
'************************************************************************
'**This program name: "Infinite Stream" paging program
'**Author: Arbiter(AAsx)
'** Version: MillionLevel
'**
'**QQ: 22222xx
'**Email: [email protected]
'**http://www.imagecity.org/
'************************************************************************
'**
'**【Author's Words】
'**
'**Paging programs are undoubtedly a more troublesome thing among many network program functions. In fact, now
'**So most people are still using the traditional paging method (Rs.PageSize=xx) and understand
'**Anyone who operates databases knows that this traditional method has a disadvantage: when you open a page for the first time,
'**It will read all recordsets, which will be fatal when the data is large, and
'**The page turn speed will be very slow and take up resources. For data above the order of 100,000
'**Ku's traditional paging method seems very powerless, let alone a million-level (it's impossible to fuck
'**do). For this reason, I was prompted to do this program.
'**
'**【Program Function】
'**
'**Page paging operations for large databases, ideally operable data records of 2 million
'**(The MaxLevel version will have no limit on the number, and no matter how large the database is, the page turn speed will be
'**Unchanged), this is the MillionLevel version of the paging program in Celeron 1G, memory 512, win2k ring
Test data in the ** situation:
'**
'**SQLserver2k+100,000 records+20 records per page:
'**Average page turn speed: 45ms
'**SQLserver2k+1 million records+20 records per page:
'**Average page turn speed: 350ms
'**
'**
'**【Page Principle】
'**
'**This program no longer uses Rs.PageSize to paginate the cursor type to connect to the database
'**It is not using conn,1,x, but conn,0,1. This should be the fastest cursor type, don't
'**Think this will make the program complicated. On the contrary, the program is very simple. If you don't understand,
'**It should be my programming style that you are not used to, not the program is complicated.
The center of the "Infinite Stream" paging is: each page only reads the records that need to be displayed, no longer like traditional ones.
'**The paging program pre-reads all data, which is the biggest advantage of this program - it occupies less resources, same
'**The management speed has also been greatly improved, especially when the data volume is larger, its speed advantage
'**The more obvious it is (1 million records are only about 350ms).
'**When the program is executed, use CurcorBegin and CurcorEnd to record the first record displayed
'**The ID value of the record and the last record is used as the mark of the next page turn, and then use Topxx to retrieve it
'**The required data is displayed, and the ID value is recorded.
'**
'**【Conclusion】
'**
'**This program is a shared version and is provided for various program enthusiasts to study and use. If you want to reprint, disseminate, or repair it
'**For modification or for other purposes, please respect the author's hard work and indicate the source.