B
Bruce
In a site that has about 4000 products, in 1000 categories, I thought that I
can store each product and category details in its own application("var"),
instead of trips to the database.
When someone will go to product.asp?id=123, the page will show the
application("product123") instead of getting the information from the
database.
If a change of pricing or availability occours, I will delete the
application("product123"). The product.asp will check if it's empty. If it
is, it will get the data from the database and show that, but the next time
someone goes to that page, there is no need to connect to the database.
I've used it many times for chunks of HTML (see
http://www.learnasp.com/freebook/asp/speedappdata.aspx), but my question is,
how much can I save in application data? Can I put 4000 of them?
can store each product and category details in its own application("var"),
instead of trips to the database.
When someone will go to product.asp?id=123, the page will show the
application("product123") instead of getting the information from the
database.
If a change of pricing or availability occours, I will delete the
application("product123"). The product.asp will check if it's empty. If it
is, it will get the data from the database and show that, but the next time
someone goes to that page, there is no need to connect to the database.
I've used it many times for chunks of HTML (see
http://www.learnasp.com/freebook/asp/speedappdata.aspx), but my question is,
how much can I save in application data? Can I put 4000 of them?