| Author |
 Topic  |
|
wii
Free ASP Hosts Moderator
Denmark
2632 Posts |
 Posted - 29 September 2005 : 15:44:11
|
Where is the guide for upgrading Access to MSQL ?
The title says it all.
I canīt find the topic that explains in easy steps how to this. It used to be sticky topic !?
Thanks |
Edited by - wii on 07 October 2005 04:15:44 |
|
|
OneWayMule
Dev. Team Member & Support Moderator
Austria
4969 Posts |
|
|
wii
Free ASP Hosts Moderator
Denmark
2632 Posts |
Posted - 29 September 2005 : 16:09:47
|
| Yeah, thanks. |
 |
|
|
OneWayMule
Dev. Team Member & Support Moderator
Austria
4969 Posts |
|
|
wii
Free ASP Hosts Moderator
Denmark
2632 Posts |
Posted - 30 September 2005 : 15:49:19
|
Ok, the upgrade went well - no problems (except one, read below) - and the forum is really fast now, running MSSQL locally on the webserver.
Just one problem - topics that have lots of pages (more than 1000) load quite slow, actually quite a bit slower than when I used Access as DB - can anyone explain why this could be? |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
wii
Free ASP Hosts Moderator
Denmark
2632 Posts |
Posted - 01 October 2005 : 03:50:40
|
| Well, but still - seems strange that just this issue is faster using Access. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 01 October 2005 : 05:01:05
|
| SQL Server is much more dependent on proper indexing than Access, though I agree it does look strange. It's quite common, though. I remember an instance where someone with a 200 MB Access DB had a given "large" search perform in about a minute in Access and two and a half minutes in SQL Server. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
MarcelG
Retired Support Moderator
Netherlands
2625 Posts |
Posted - 01 October 2005 : 08:23:56
|
| Rui, is there a clever way of solving that on the SQL server side ? Or would that require code changes ? |
portfolio - linkshrinker - oxle - twitter |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 01 October 2005 : 09:03:15
|
| A proper choice of indexes should be able to help with that... Anyway, there's something that needs to be asked: what driver is being used to connect to the database? The SQLOLEDB or the ODBC driver? |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
wii
Free ASP Hosts Moderator
Denmark
2632 Posts |
Posted - 01 October 2005 : 11:17:14
|
| SQLOLEDB |
Edited by - wii on 01 October 2005 11:18:59 |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
caxps
Starting Member
35 Posts |
Posted - 01 October 2005 : 15:27:01
|
| what code changes are required for conversion to SQL? |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
wii
Free ASP Hosts Moderator
Denmark
2632 Posts |
Posted - 02 October 2005 : 05:03:39
|
What can be done about the indexing?
Itīs the only performance problem I have after converting MSSQL - everything else is much faster !
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Topic |
|
Topic Locked
