Caching performance question

[guitardave78]

What would you think is best out of these situations.
I have a page that is pretty sql heavy.
At the moment I have set up a caching routine that will store the output into a couple of application variables and then only query the database for new content after the expiration date.

My idea is to convert this so that it writes a text file and uses it the same way, reads it in using fso or writes the new one if the date of the files is past the expiration date.

Which would be best from an overhead / performance view point?

}...the bane of my life!

http://www.yetanotherreviewsite.co.uk

http://www.fuzzyd.co.uk

 

[onpnt]

You'll really need to test out the performance on the FSO object vs. the data objects. My first guestimation is the the data access objects are going to win over file system objects based mainly on cursor navigation through your data.

Try looking into disconnected recordsets. That may be your best option

[sub]____________ signature below ______________
The worst mistake you'll ever make is to do something simply the way you know how while ignoring the way it should be done[/sub]

 

[guitardave78]

Although the fso method is a little neater in places, it is about double the time of the application method!!

}...the bane of my life!

http://www.yetanotherreviewsite.co.uk

http://www.fuzzyd.co.uk