| Author |
 Topic  |
|
|
work mule
Senior Member
USA
1358 Posts |
 Posted - 21 March 2001 : 05:55:45
|
I had read this article at 15seconds.com about caching data for listboxes. The performance gains that were listed in the article were impressive. I thought it would be cool if the jump to list for the Snitz forum could be cached, especially since it doesn't change much. So I made an attempt at doing this.
It seems to work okay, but I only tested it on a very small test site. I have no idea how much memory this would take up as an application variable, especially for larger sites. I think if it's not too much memory, it's a good tradeoff versus having to hit the database for this everytime. Also I don't have much experience in arrays in VBscript and I was having trouble with some of it. I couldn't seem to make an array with over two dimensions work, so I had to work around it. It works tho'.
Is this good? bad? Is there a different way to do this? If anyone could take a look and provide some feedback, it would be appreciated! 
Download - Zip File:
http://www.execpc.com/~literati/devforum_downloads/mods/inc_jump_to.zip
The article at 15seconds.com:
Get Your Data Faster with a Data Cache
http://www.15seconds.com/issue/000608.htm
|
|
|
tilttek
Junior Member
Canada
333 Posts |
Posted - 21 March 2001 : 09:35:11
|
quote:
I had read this article at 15seconds.com about caching data for listboxes. The performance gains that were listed in the article were impressive. I thought it would be cool if the jump to list for the Snitz forum could be cached, especially since it doesn't change much. So I made an attempt at doing this.
It seems to work okay, but I only tested it on a very small test site. I have no idea how much memory this would take up as an application variable, especially for larger sites. I think if it's not too much memory, it's a good tradeoff versus having to hit the database for this everytime. Also I don't have much experience in arrays in VBscript and I was having trouble with some of it. I couldn't seem to make an array with over two dimensions work, so I had to work around it. It works tho'.
I did someting similar... I create an include file, when I add/modify/delete a forum, I just write the file (generating the file) so when it's included I doesn't go to the DB nor use memory.
Philippe Gamache
http://www.tilttek.com
http://www.lapageamelkor.com |
 |
|
|
Kerry
Average Member
USA
553 Posts |
Posted - 21 March 2001 : 10:20:21
|
Nice idea to do that with the jumpboxes, tilttek . I use the same thing to generate all of the content for my main page (www.cantonweb.com/index.asp - absolutely zero db connections there) as well as about 400 search engine-friendly pages based on my web directory database (http://www.cantonweb.com/searchfor/).
-Kerry
|
|
|
|
work mule
Senior Member
USA
1358 Posts |
Posted - 21 March 2001 : 10:34:04
|
I agree that the include would be a better solution. I could just recreate that include file everytime the categories or forums are updated. But for people who don't/can't do it that way, I thought maybe this would be a good alternative.
|
|
|
|
Kerry
Average Member
USA
553 Posts |
Posted - 21 March 2001 : 13:54:15
|
Agreed - I know several ISP's that either restrict or completely disallow FSO. As a Snitz mod it's better to go with something everyone can use.
Good call on the need for it  .
-Kerry
|
|
|
|
tilttek
Junior Member
Canada
333 Posts |
Posted - 21 March 2001 : 15:35:51
|
quote:
Agreed - I know several ISP's that either restrict or completely disallow FSO. As a Snitz mod it's better to go with something everyone can use.
Good call on the need for it .
Maybe we could have both Mod available :-)
Philippe Gamache
http://www.tilttek.com
http://www.lapageamelkor.com |
|
|
| |
Topic |
|
Topic Locked
