Generating ASP

Problems with speed

[drill]

Hi

I'm new in ASP coding and i have a problem

I send *.mdb to my web page every day. I would like to know is there a way to open those pages which use *.mdb one time and store them on server so that they work faster.

[txbakers]

Hi and Welcome to Webmaster World!

I'm not entirely clear on your process.

Are you uploading the Access DB file to your server every day and want to automate that?

Or, are you saying that your web pages are slow because it has to access the DataBase every day?

Please clarify for us and I'm sure someone can help you out.

[Rhadamanthus]

If I understand you correctly, you have a website that is dynamically generated from a database in a Microsoft Jet database file (.mdb). But since you only update it once per day, you want to cache the pages so that they're only generated when you update the database and not every single time somebody loads a page, correct?

I don't know if you can do this in regular ASP (never used it), but ASP.NET has some pretty advanced caching features that actually make this pretty simple. This is one of the main reasons why I'm converting my entire (dynamically generated) site over from an Apache/PHP solution to an IIS/ASP.NET solution.

Are you using ASP.NET or plain vanilla ASP?

[drill]

I want to cache pages only when I change the Acecess DB.

Is it possible in plain ASP?

Is a big diference between plain ASP and ASP.Net

[Rhadamanthus]

>>Is a big diference between plain ASP and ASP.Net

Big enough that it's non-trivial, not so big that it's impossible. I don't know if there's a way to do caching in plain ASP or not.

If you don't have that many pages, the simplist thing to do would be to simply load the page once in your browser and then do a "save as". It would save it as just HTML, which you could then place on your server instead of your ASP based pages. Alternatively, you could write a script to do this for you.

It's not the best solution I know. Sorry I can't be more help than that. Maybe somebody else has a better idea.

[Iguana]

I generate a 3000 HTML page site from an access database every week (using VB to read the db and write the pages) and upload through FTP.

Although an ASP developer in my day job - it is a much simpler solution than developing a dynamically generated site since I can use cheap and powerful Linux hosting.

[Xoc]

Well, you could save the info into a file, save an application variable with the date of last update, and if the date+1 day is past, reload the file.

However, the easier way is to upgrade to .NET. In .NET, each web page can have a cache directive that tells it how long to automatically cache the page.