| Author |
 Topic  |
|
stratacafe
Starting Member
Canada
44 Posts |
 Posted - 27 February 2002 : 22:11:44
|
Still running (fingers crossed).
Will moving to something like MySQL really speed things up that much? MS-SQL is out of my budget (free), so that's a no-go.
< |
 |
|
|
Deleted
deleted
4116 Posts |
Posted - 28 February 2002 : 05:06:06
|
quote:
Still running (fingers crossed).
Will moving to something like MySQL really speed things up that much? MS-SQL is out of my budget (free), so that's a no-go.
Keep them crossed  . This topic includes some links about MySQL : http://forum.snitz.com/forum/topic.asp?TOPIC_ID=23418
A major issue is to move from one database to the other. I never used MySQL, so it will be a good idea to search, if not found ask using the MySQL support forum here.
Think PinkPost v40b03 Patches< |
|
|
|
stratacafe
Starting Member
Canada
44 Posts |
Posted - 28 February 2002 : 19:40:00
|
1 last post for the sake of closure.
A whole day, no crashes! Yippee!
There seems to be some serious issue with scalability/stability with Access97 databases. Converting to 2000 has done the trick.
Thanks for your help Bozden, although most of the info I posted seems to have been a red herring.
I will definately look up that info on MySQL. Squeezing some more speed ot of this baby (and the whole site in general) is foremost on my mind right now.
< |
|
|
|
Deleted
deleted
4116 Posts |
Posted - 28 February 2002 : 20:10:23
|
quote:
1 last post for the sake of closure.
A whole day, no crashes! Yippee!
Thanks for your help Bozden, although most of the info I posted seems to have been a red herring.
You're welcome .
quote:
There seems to be some serious issue with scalability/stability with Access97 databases. Converting to 2000 has done the trick.
Well, you may call it like that. Backward compatibility is a bad issue for programmers/computer engineers. It is a Jet driver "issue". Think of how old Access 97 is (3 generations backwards). You have to get rid of it somewhere to make things work better.
Think PinkPost v40b03 Patches< |
|
|
|
aecio
Junior Member
Brazil
120 Posts |
Posted - 04 March 2002 : 20:16:38
|
This thread got very interesting!
Now, as for the test I proposed. I installed the internationalized 4.03 version with English as the default and only language. And I put up a parallel forum with the 3.3 version.
Does anyone have an idea to "time" the difference in loading and processing between these? I thought of getting log results in the IIS logs for load time, but I don't know if this is being logged.
Cheers! 
Visit the Healthy Planet online support community:
http://www.xsaude.com.br/healthyplanet/< |
|
|
|
aecio
Junior Member
Brazil
120 Posts |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 27 April 2002 : 06:15:47
|
Funny thing, 4.0 loaded a whole lot faster than 3.3 to me.
You could properly set the timer at the bottom of the page to show the time it takes for the server to generate each page. Right now it seems that you have the part in inc_footer.asp uncommented, but the part in inc_top.asp must be commented (the value being shown now is always the same and it as an absurd one.
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs< |
|
|
|
Deleted
deleted
4116 Posts |
Posted - 27 April 2002 : 10:20:04
|
The problem with this is, you are making the test in a chaotic environment called "Internet".
To be able to test the following set-up would be needed:
- A dedicated server for the test, without unnecessary processes
- A dedicated client for the test (Intranet)
- No other restriction (so you use max memory, bandwidth etc)
- Run something like web stress tool
Think Pink
==> Start Internationalization Here< |
|
|
|
aecio
Junior Member
Brazil
120 Posts |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 27 April 2002 : 23:02:06
|
I know it's not meaningful, but 4.0 took 1.06 secs to be generated at the server and 3.03 took 1.07...
This confirms my previous impressions at your site...
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs< |
|
|
|
Deleted
deleted
4116 Posts |
Posted - 28 April 2002 : 17:08:59
|
quote:
Since for all our forum's users, version 3 was faster, I switched them around. Our oficial version is now 3.
Can you try to make all language variables to constansts and try to compare again? I.e. in your LangNNNN.asp files, use a global find-replace to get
Const strLangActive00010 = "...
Const strLangActive00020 = "...
...
Think Pink
==> Start Internationalization Here< |
|
|
|
Topic |
|
Forum Locked
