script performance - Access DB

1. Simop Administrator Joined: Dec 2002 Warrington Posts: 20561 Blue Saxo VTS Turbo/White Megane F1 R26

   #1 6th January 2004, 23:33

   Server investigations are currently underway.
   
   Please could a few of you log your script execution times here..
   
   Thanks,
   
2. Bish Newbie Joined: Jan 2004 Posts: 1

   #2 7th January 2004, 00:07

   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
3. GreenSaxo Saxperience Addict Joined: Dec 2002 Ashford, Kent, United Kingdom (England) Posts: 12835 Cammed Saxo "desire" 16v

   #3 7th January 2004, 00:07

   gen chat : Script Execution: 5.17 seconds
   
   this thread: Script Execution: 4.12 seconds
   
   
   
4. GreenSaxo Saxperience Addict Joined: Dec 2002 Ashford, Kent, United Kingdom (England) Posts: 12835 Cammed Saxo "desire" 16v

   #4 7th January 2004, 00:08

   to do above reply and show thread: Script Execution: 1.08 seconds
5. GreenSaxo Saxperience Addict Joined: Dec 2002 Ashford, Kent, United Kingdom (England) Posts: 12835 Cammed Saxo "desire" 16v

   #5 7th January 2004, 00:39

   been getting lots of
   
   internal server errors and other errors for last 10mins
   
   load this thread: Script Execution: 1.31 seconds
6. Scottp Administrator Joined: Dec 2002 Glasgow United Kingdom (Scotland) Posts: 26097 Chelski Traktor

   #6 7th January 2004, 01:37

   Script Execution: 22.02 seconds
   
   and thats me on the new broadband and my new pc
7. GreenSaxo Saxperience Addict Joined: Dec 2002 Ashford, Kent, United Kingdom (England) Posts: 12835 Cammed Saxo "desire" 16v

   #7 7th January 2004, 05:20

   on my newish pc and snail-up to load this thread: Script Execution: 1.48 seconds
8. Simop Administrator Joined: Dec 2002 Warrington Posts: 20561 Blue Saxo VTS Turbo/White Megane F1 R26

   #8 7th January 2004, 15:27

   Quote:

   Originally Posted by 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

   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..
   
   Regarding yesterday's poor server performance, fasthosts have admitted a server problem and say the issue is resolved. Fingers crossed.
   
   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
   
   
   
   Script Execution: 0.83 seconds Transactions: 20
   
9. Areke Saxperience Addict Joined: Dec 2002 Zoelen Netherlands Posts: 11927 Subaru Impreza 2.5t WRX Seat Leon 1.9D businessli

   #9 7th January 2004, 15:30

   Script Execution: 0.88 seconds
10. Areke Saxperience Addict Joined: Dec 2002 Zoelen Netherlands Posts: 11927 Subaru Impreza 2.5t WRX Seat Leon 1.9D businessli

    #10 7th January 2004, 15:31

    Script Execution: 2.59 seconds
11. Areke Saxperience Addict Joined: Dec 2002 Zoelen Netherlands Posts: 11927 Subaru Impreza 2.5t WRX Seat Leon 1.9D businessli

    #11 7th January 2004, 15:32

    Script Execution: 0.71 seconds
12. Areke Saxperience Addict Joined: Dec 2002 Zoelen Netherlands Posts: 11927 Subaru Impreza 2.5t WRX Seat Leon 1.9D businessli

    #12 7th January 2004, 15:33

    Script Execution: 5.91 seconds
13. Simop Administrator Joined: Dec 2002 Warrington Posts: 20561 Blue Saxo VTS Turbo/White Megane F1 R26

    #13 7th January 2004, 15:33

    
    
    Hi Ar'
14. Areke Saxperience Addict Joined: Dec 2002 Zoelen Netherlands Posts: 11927 Subaru Impreza 2.5t WRX Seat Leon 1.9D businessli

    #14 7th January 2004, 15:45

    hi simo
15. GreenSaxo Saxperience Addict Joined: Dec 2002 Ashford, Kent, United Kingdom (England) Posts: 12835 Cammed Saxo "desire" 16v

    #15 7th January 2004, 18:27

    Script Execution: 72.27 seconds
16. GreenSaxo Saxperience Addict Joined: Dec 2002 Ashford, Kent, United Kingdom (England) Posts: 12835 Cammed Saxo "desire" 16v

    #16 7th January 2004, 18:29

    to do above reply...
    
    Script Execution: 5.31 seconds
17. GreenSaxo Saxperience Addict Joined: Dec 2002 Ashford, Kent, United Kingdom (England) Posts: 12835 Cammed Saxo "desire" 16v

    #17 7th January 2004, 18:32

    to do above reply
    
    Script Execution: 45.69 seconds
18. Keir Established Member Joined: Dec 2002 Bedford United Kingdom (England) Posts: 1428

    #18 7th January 2004, 18:37

    Script Execution: 5.72 seconds
19. Simop Administrator Joined: Dec 2002 Warrington Posts: 20561 Blue Saxo VTS Turbo/White Megane F1 R26

    #19 7th January 2004, 18:45

    Just sit back and wait for the new database now then 's
20. GreenSaxo Saxperience Addict Joined: Dec 2002 Ashford, Kent, United Kingdom (England) Posts: 12835 Cammed Saxo "desire" 16v

    #20 8th January 2004, 00:14

    ok
    
    im waiting
    
    
21. saxostu Established Member Joined: Feb 2003 Kent United Kingdom (England) Posts: 1623

    #21 8th January 2004, 01:57

    Still waiting
22. Smithy2003 Established Member Joined: Nov 2003 Brighouse United Kingdom (England) Posts: 1072

    #22 8th January 2004, 03:27

    Script execution: Far too long
    Transactions: Not many
    
    Script execution: 2.91
    Transactions: 21
23. Scottp Administrator Joined: Dec 2002 Glasgow United Kingdom (Scotland) Posts: 26097 Chelski Traktor

    #23 8th January 2004, 07:51

    Script Execution: 2.69 seconds Transactions: 21
    
    although it has been working a fair bit better tonight
24. GreenSaxo Saxperience Addict Joined: Dec 2002 Ashford, Kent, United Kingdom (England) Posts: 12835 Cammed Saxo "desire" 16v

    #24 10th January 2004, 06:44

    Script Execution: 1.89 seconds Transactions: 21
    
    getting there
    
    
25. Scottp Administrator Joined: Dec 2002 Glasgow United Kingdom (Scotland) Posts: 26097 Chelski Traktor

    #25 10th January 2004, 06:51

    Script Execution: 0.59 seconds Transactions: 21
    
    far better
26. GreenSaxo Saxperience Addict Joined: Dec 2002 Ashford, Kent, United Kingdom (England) Posts: 12835 Cammed Saxo "desire" 16v

    #26 10th January 2004, 06:55

    Script Execution: 0.73 seconds Transactions: 21