| Saxperience Announcements & Updates Saxperience is continually evolving and adapting. Notices introducing / explaining changes to the functionality of the community will be posted within this forum. |
 |
|
6th January 2004, 23:33
|
#1
|
|
Administrator
Join Date: Dec 2002
Location: Warrington
Posts: 20,551
Car(s): Blue Saxo VTS Turbo/White Megane F1 R26
|
script performance - Access DB
Server investigations are currently underway.
Please could a few of you log your script execution times here.. 
Thanks,
|
|
|
|
7th January 2004, 00:07
|
#2
|
|
Newbie
Join Date: Jan 2004
Posts: 1
|
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 
|
|
|
|
|
7th January 2004, 00:07
|
#3
|
|
Saxperience Addict
Join Date: Dec 2002
Location: Ashford, Kent, United Kingdom (England)
Posts: 12,835
Car(s): Cammed Saxo "desire" 16v
|
gen chat : Script Execution: 5.17 seconds
this thread: Script Execution: 4.12 seconds
|
|
|
|
|
7th January 2004, 00:08
|
#4
|
|
Saxperience Addict
Join Date: Dec 2002
Location: Ashford, Kent, United Kingdom (England)
Posts: 12,835
Car(s): Cammed Saxo "desire" 16v
|
to do above reply and show thread: Script Execution: 1.08 seconds
|
|
|
|
|
7th January 2004, 00:39
|
#5
|
|
Saxperience Addict
Join Date: Dec 2002
Location: Ashford, Kent, United Kingdom (England)
Posts: 12,835
Car(s): Cammed Saxo "desire" 16v
|
been getting lots of
internal server errors and other errors for last 10mins 
load this thread: Script Execution: 1.31 seconds
|
|
|
|
|
7th January 2004, 01:37
|
#6
|
|
Administrator
Join Date: Dec 2002
Location: Glasgow United Kingdom (Scotland)
Posts: 26,097
Car(s): Chelski Traktor
|
Script Execution: 22.02 seconds
and thats me on the new broadband and my new pc
|
|
|
|
|
7th January 2004, 05:20
|
#7
|
|
Saxperience Addict
Join Date: Dec 2002
Location: Ashford, Kent, United Kingdom (England)
Posts: 12,835
Car(s): Cammed Saxo "desire" 16v
|
on my newish pc and snail-up  to load this thread: Script Execution: 1.48 seconds
|
|
|
|
|
7th January 2004, 15:27
|
#8
|
|
Administrator
Join Date: Dec 2002
Location: Warrington
Posts: 20,551
Car(s): Blue Saxo VTS Turbo/White Megane F1 R26
|
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
|
|
|
|
|
7th January 2004, 15:30
|
#9
|
|
Saxperience Addict
Join Date: Dec 2002
Location: Zoelen Netherlands
Posts: 11,927
Car(s): Subaru Impreza 2.5t WRX
Seat Leon 1.9D businessli
|
Script Execution: 0.88 seconds
__________________
|
|
|
|
|
7th January 2004, 15:31
|
#10
|
|
Saxperience Addict
Join Date: Dec 2002
Location: Zoelen Netherlands
Posts: 11,927
Car(s): Subaru Impreza 2.5t WRX
Seat Leon 1.9D businessli
|
Script Execution: 2.59 seconds
__________________
|
|
|
|
|
7th January 2004, 15:32
|
#11
|
|
Saxperience Addict
Join Date: Dec 2002
Location: Zoelen Netherlands
Posts: 11,927
Car(s): Subaru Impreza 2.5t WRX
Seat Leon 1.9D businessli
|
Script Execution: 0.71 seconds
__________________
|
|
|
|
|
7th January 2004, 15:33
|
#12
|
|
Saxperience Addict
Join Date: Dec 2002
Location: Zoelen Netherlands
Posts: 11,927
Car(s): Subaru Impreza 2.5t WRX
Seat Leon 1.9D businessli
|
Script Execution: 5.91 seconds
__________________
|
|
|
|
|
7th January 2004, 15:33
|
#13
|
|
Administrator
Join Date: Dec 2002
Location: Warrington
Posts: 20,551
Car(s): Blue Saxo VTS Turbo/White Megane F1 R26
|
Hi Ar'
|
|
|
|
|
7th January 2004, 15:45
|
#14
|
|
Saxperience Addict
Join Date: Dec 2002
Location: Zoelen Netherlands
Posts: 11,927
Car(s): Subaru Impreza 2.5t WRX
Seat Leon 1.9D businessli
|
hi simo 
__________________
|
|
|
|
|
7th January 2004, 18:27
|
#15
|
|
Saxperience Addict
Join Date: Dec 2002
Location: Ashford, Kent, United Kingdom (England)
Posts: 12,835
Car(s): Cammed Saxo "desire" 16v
|
Script Execution: 72.27 seconds
|
|
|
|
|
7th January 2004, 18:29
|
#16
|
|
Saxperience Addict
Join Date: Dec 2002
Location: Ashford, Kent, United Kingdom (England)
Posts: 12,835
Car(s): Cammed Saxo "desire" 16v
|
to do above reply...
Script Execution: 5.31 seconds
|
|
|
|
|
7th January 2004, 18:32
|
#17
|
|
Saxperience Addict
Join Date: Dec 2002
Location: Ashford, Kent, United Kingdom (England)
Posts: 12,835
Car(s): Cammed Saxo "desire" 16v
|
to do above reply
Script Execution: 45.69 seconds
|
|
|
|
|
7th January 2004, 18:37
|
#18
|
|
Established Member
Join Date: Dec 2002
Location: Bedford United Kingdom (England)
Posts: 1,428
|
Script Execution: 5.72 seconds
__________________
306 Rallye - God's own hot hatch
|
|
|
|
|
7th January 2004, 18:45
|
#19
|
|
Administrator
Join Date: Dec 2002
Location: Warrington
Posts: 20,551
Car(s): Blue Saxo VTS Turbo/White Megane F1 R26
|
Just sit back and wait for the new database now then 's
|
|
|
|
|
8th January 2004, 00:14
|
#20
|
|
Saxperience Addict
Join Date: Dec 2002
Location: Ashford, Kent, United Kingdom (England)
Posts: 12,835
Car(s): Cammed Saxo "desire" 16v
|
|
|
|
|
| Thread Tools |
|
|
| Display Modes |
 Linear Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
All times are GMT. The time now is 09:37.
|
button at the side of the post.
