script performance - Access DB

[Simo]

Server investigations are currently underway.

Please could a few of you log your script execution times here.. smileys/smiley5.gif

Thanks,

[Bish]

Hi Simo

Just read your post on the Fasthosts Forum regarding the timeouts with your AccessDB. I had excatly the same thing when I first created a site with Fasthosts with an AccessDB backend. When I did speak to Fasthosts they said that I shouldn't be using Access because they don't fully support it!! Go figure!!
Anyways, I eventually convert my AccessDB to a MySQL one using a Access2MySQL Converter. Then all I had to do is change the connection string in my ASP pages and volia! All is now A1 perfect and much faster!! If you want a copy of the prog, let me know and I'll email it to you.

Regards

Bish smileys/smiley16.gif

[GreenSaxo]

gen chat : Script Execution: 5.17 seconds

this thread: Script Execution: 4.12 seconds

[GreenSaxo]

to do above reply and show thread: Script Execution: 1.08 seconds

[GreenSaxo]

been getting lots of

internal server errors and other errors for last 10mins smileys/sad.gif

load this thread: Script Execution: 1.31 seconds

[Scott]

Script Execution: 22.02 seconds

smileys/sad.gif and thats me on the new broadband and my new pc

[GreenSaxo]

on my newish pc and snail-up smileys/smiley17.gif to load this thread: Script Execution: 1.48 seconds

[Simo]

Hi Simo

Just read your post on the Fasthosts Forum regarding the timeouts with your AccessDB. I had excatly the same thing when I first created a site with Fasthosts with an AccessDB backend. When I did speak to Fasthosts they said that I shouldn't be using Access because they don't fully support it!! Go figure!!
Anyways, I eventually convert my AccessDB to a MySQL one using a Access2MySQL Converter. Then all I had to do is change the connection string in my ASP pages and volia! All is now A1 perfect and much faster!! If you want a copy of the prog, let me know and I'll email it to you.

Regards

Bish smileys/smiley16.gif

Thanks for the comment Bish,

I decided a long time ago that Access had to go and last night I finally made the decision to move away from it! MySQL seems to be the best alternative, which also leaves the option of moving to PHP in the future.. smileys/smiley14.gif

Regarding yesterday's poor server performance, fasthosts have admitted a server problem and say the issue is resolved. Fingers crossed. smileys/smiley9.gif

Scott, regarding your broadband/script times... the time noted is the time it takes the server to process the code on the page, before sending it to your browser... so having broadband shouldn't really affect the script time... it was just the server was being smileys/gay.gif

smileys/smiley17.gif

Script Execution: 0.83 seconds Transactions: 20

[Areke]

Script Execution: 0.88 seconds

[Areke]

Script Execution: 2.59 seconds

[Areke]

Script Execution: 0.71 seconds

[Areke]

Script Execution: 5.91 seconds

[Simo]

smileys/smiley17.gif

Hi Ar'

[Areke]

hi simo smileys/kiss2.gif

[GreenSaxo]

Script Execution: 72.27 seconds

[GreenSaxo]

to do above reply...

Script Execution: 5.31 seconds

[GreenSaxo]

to do above reply

Script Execution: 45.69 seconds

[Keir]

Script Execution: 5.72 seconds

[Simo]

Just sit back and wait for the new database now then smileys/gay.gif's

[GreenSaxo]

ok smileys/smiley17.gif

im waiting smileys/smiley17.gif

smileys/smiley22.gif smileys/smiley22.gif smileys/smiley24.gif smileys/smiley24.gif

[saxostu]

Still waiting smileys/smiley17.gif

[Smithy2003]

Script execution: Far too long
Transactions: Not many

Script execution: 2.91
Transactions: 21

[Scott]

Script Execution: 2.69 seconds Transactions: 21

although it has been working a fair bit better tonightsmileys/smiley17.gif

[GreenSaxo]

Script Execution: 1.89 seconds Transactions: 21

getting there smileys/smiley17.gif smileys/smiley17.gif

[Scott]

Script Execution: 0.59 seconds Transactions: 21

far bettersmileys/smiley20.gif

[GreenSaxo]

Script Execution: 0.73 seconds Transactions: 21