| Author |
 Topic  |
|
SiSL
Average Member
Turkey
671 Posts |
|
|
MarcelG
Retired Support Moderator
Netherlands
2625 Posts |
 Posted - 23 December 2008 : 04:13:46
|
quote:
Originally posted by SiSL
Why not SQL 2008?
2008 FT, ROW_ID, RANK, DENSE-RANK are perfect things :p
Well, that's easy to answer: my hosting provider does not provide SQL2008, they only provide SQL2000.  < |
portfolio - linkshrinker - oxle - twitter |
 |
|
|
MarcelG
Retired Support Moderator
Netherlands
2625 Posts |
Posted - 23 December 2008 : 08:21:50
|
Guys, I've done it....yeah, I know I'm a daredevil. 
Anyway, oxle is now migrated to my new hostingprovider and more importantly : it's migrated to SQL2000! Yay!< |
portfolio - linkshrinker - oxle - twitter |
|
|
|
SiSL
Average Member
Turkey
671 Posts |
|
|
MarcelG
Retired Support Moderator
Netherlands
2625 Posts |
Posted - 23 December 2008 : 09:42:00
|
hehe, well it's at least better than MS Access 2000. 
I'm going to look into further optimizing the site and SQL database to see if I can squeeze out some more performance. I expect this subforum has some valuable topics for me.
I've also inquired if it's possible to enable IIS compression, as I spotted they haven't enabled that there yet.< |
portfolio - linkshrinker - oxle - twitter |
|
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 23 December 2008 : 10:07:19
|
quote:
Originally posted by SiSL
NEW hostingprovider? Man... That's 8 years old behind technology provider :P
Well, its new to him.  < |
|
|
|
SiSL
Average Member
Turkey
671 Posts |
|
|
MarcelG
Retired Support Moderator
Netherlands
2625 Posts |
|
|
SiSL
Average Member
Turkey
671 Posts |
|
|
balexandre
Junior Member
Denmark
418 Posts |
Posted - 25 December 2008 : 14:13:13
|
quote:
Originally posted by MarcelG
Well, that's easy to answer: my hosting provider does not provide SQL2008, they only provide SQL2000.
everyone gives you SQL 2008 (if using a Windows hosting), it's only a file! use SQL Server 2008 Express Edition, you don't need a full server for Snitz! (as long as you don't passed 4Gb of data at least)
By the way, how many rows your FORUM_REPLY table has? mine has more than 35.000 and I'm thinking to move the DB to SQL as well < |
Bruno Alexandre
(Strøby, DANMARK)
"a Portuguese in Danmark"
|
Edited by - balexandre on 25 December 2008 14:18:06 |
|
|
|
golfmann
Junior Member
United States
450 Posts |
Posted - 26 December 2008 : 14:07:11
|
Congrats Marcel!
It works GOOD too!
Much faster! < |
|
|
|
MarcelG
Retired Support Moderator
Netherlands
2625 Posts |
Posted - 28 December 2008 : 08:06:28
|
quote:
Originally posted by balexandre
quote:
Originally posted by MarcelG
Well, that's easy to answer: my hosting provider does not provide SQL2008, they only provide SQL2000.
everyone gives you SQL 2008 (if using a Windows hosting), it's only a file!
No, they provide SQL2000, not SQL Express 2008.
It's not just 'a file'....
quote:
By the way, how many rows your FORUM_REPLY table has? mine has more than 35.000 and I'm thinking to move the DB to SQL as well
roughly 33000.< |
portfolio - linkshrinker - oxle - twitter |
|
|
|
balexandre
Junior Member
Denmark
418 Posts |
Posted - 28 December 2008 : 09:18:19
|
I meant SQL Server 2008 Express Edition ... it is just a file an mdf file
You don't need to go to the full Server environment, Express edition is more than suitable for Snitz Forum.< |
Bruno Alexandre
(Strøby, DANMARK)
"a Portuguese in Danmark"
|
Edited by - balexandre on 28 December 2008 09:19:05 |
|
|
|
Topic |
|
Topic Locked
