Support Forum

Advanced Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
general-topic
Separate database for forum
Avatar
Mike Miler
Member
sp_UserOfflineSmall Offline
Jun 29, 2017 - 10:20 am

Hey,

is there an easy way to put all forum related tables to a different database?

Best,
Mike

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Jun 29, 2017 - 12:07 pm

The main problem doing that is cross-database queries which, I understand, can be notoriously slow. 

Adding support in to allow for it could be done but I would worry about the consequences. Can I ask the reason behind the question?

andy-signature.png
YELLOW
SWORDFISH
Avatar
Mike Miler
Member
sp_UserOfflineSmall Offline
Jul 5, 2017 - 2:57 pm

My client was asking but I also dont really see a big advantage... Just wanted to ask if you already have a solution for it.

Thank you for your reply!

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Jul 5, 2017 - 9:18 pm

no worries!  here to help...

Forum Timezone: Europe/Stockholm
Most Users Ever Online: 1170
Currently Online:
Guest(s) 1
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Mr Papa: 19448
Ike: 2086
Brandon: 864
kvr28: 804
jim: 650
FidoSysop: 577
Conrad_Farlow: 531
fiddlerman: 358
Stefano Prete: 325
Member Stats:
Guest Posters: 620
Members: 17365
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10128
Posts: 79626