Lets say i have 3000 products. If i want to display only a 10 records page, i still have to query my 3000 products. So that each time someone access the page, all the products will be returned by my query, to show only 10 products.. isnt that bad ?
did you read this<BR><BR>objPagingRS.PageSize = iPageSize<BR><BR>objPagingRS.CacheSize = iPageSize<BR><BR>you are setting the page and cache size. so you will only be retrieving that many # of records.<BR><BR><BR><BR><BR>
Definition from devGuru.com : The CacheSize property sets or returns a long value that defines how many records can be stored in the local cache for the client.[...]<BR><BR>In the local cache for the client ?? isnt the asp code server side ? and the default value is 1 anyway. Then even if i retrieve 3000 record only one will be cached and it doesnt change anything to change the cache to rs.pagesize. Especially if its a static recordset.<BR><BR>Does the query still returns my 3000 records ? If it returns only one record that is placed in the cache, it is pointless to set the cursor type to static, since it retrieves another record if you MoveNext... to place it in the cache ..<BR><BR>Definition continued : [...]On the negative side, records stored in a cache may not reflect real-time underlying changes being made to the database by other users. [...]<BR><BR><BR>Ok, i know im still a rookie, and you're probably right ;)<BR>so please tell me where im wrong .. because im completly confused here :(