--------Original Message-----
From: Taco Fleur
Sent: Tuesday, 9 December 2003 1:36 PM
To: CFAussie Mailing List
Subject: [cfaussie] CachingYou know what would be nice?
A session like Caching functionality, i.e. Cache session for 5 minutes, if the Cached version is accessed again within 5 minutes, the cache time extends itself another 5 minutes and so on. If not accessed again within 5 minutes then expire...
Does it exist?
Can it be done without writing the resultset to a file?Today I am looking into some optimized ways for paging!
I personally don't think caching a query and then page through it is an optimized way of performing paging, why not? Because it doesn't make sense to me to transfer a resultset of 2000 records (could be any number) from the db to cf and cache it, while the user could perform another search after viewing the first 10, or close the browser.OK, you can immediately flush the cached query if another search is performed by the user, but that does not take away the fact we first transfered 2000 records while only 10 where needed.
Working with temp tables in the db isn't the solution either, what about "ODBC API server cursors"? Will they do the trick?
It sounds like MS SQL needs a cool "LIMIT" function like MySQL has.
Taco Fleur
---
Tell me and I will forget
Show me and I will remember
Teach me and I will learn
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia
http://www.mxdu.com/ + 24-25 February, 2004
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia
http://www.mxdu.com/ + 24-25 February, 2004
