Can Interbase and MSSQL2K co exist happily on the same server ?

Capt'n Midnight · 2003-12-15 17:01:56

Ok yes I know it would be better having them on different servers, are there any reaons to keep them apart. SQL will be the main dB , several GB's, while the Intebase dB wouldn't ever be more than a few ten's of MB and I don't want to stick it on to a mail server instead unless I have to.

15-12-2003 06:01PM

#1

Capt'n Midnight

Moderators, Recreation & Hobbies Moderators, Science, Health & Environment Moderators, Technology & Internet Moderators Posts: 98,142 Mod ✭✭✭✭

Join Date: March 2003

Posts: 96379

Ok yes I know it would be better having them on different servers, are there any reaons to keep them apart.

SQL will be the main dB , several GB's, while the Intebase dB wouldn't ever be more than a few ten's of MB and I don't want to stick it on to a mail server instead unless I have to.

0

Comments

#2 15-12-2003 11:00PM

dazberry

Registered Users, Registered Users 2 Posts: 2,159 ✭✭✭

Join Date: October 2001

Posts: 2051

Yes.

[aside]Older versions of IB don't run well on multiprocessor boxes. If you've to run an older version in that scenerio, tie the process affinity to one processor - there's a utility to do this, can't remember off the top of my head but I'll find out if you need. There is one version that is MP aware but doesn't take advantage if it. Best bet is to try and use the latest interbase or firebird version.

D.

0
#3 15-12-2003 11:50PM

Capt'n Midnight

Moderators, Recreation & Hobbies Moderators, Science, Health & Environment Moderators, Technology & Internet Moderators Posts: 98,142 Mod ✭✭✭✭

Join Date: March 2003

Posts: 96379

It'll probably be the latest version - down to the vendor really - also SQL is bound to one processor already.

0