The other thing you should consider, in an IB vs MS-SQL decision, is your need for
transaction handling (read 2 phase commits).
Because SQL-Server is based on Sybase DbLib (I think that's the right one) it can only
handle 1 cursor per connection.
This has 2 effects:
1. If you do 2 successive queries against a single TDatabase (single TSession) (eg
"SELECT * FROM MyMillionRowTable" followed by "SELECT PrimaryKey FROM MyOtherTable
WHERE
PrimaryKey = :Value") then the BDE will Fetch All the rows in the 1st query in an
attempt
to pretend you're still seeing both - like sending the apprentice out for a long
weight.
2. Or.. you use multiple sessions and handle transactions explicitly. I spoke to the
MS
Program Manager at the last Tech-Ed about SQL-Server 7 and the model has not changed.
Their answer - use MTS - which is fine, and Delphi will do it, but like using multiple
sessions and handling it yourself - it's more work: read higher cost of development.
Then again, as the Program Manager pointed out, you could use Access or VB to do the
development (he had a his tongue firmly in his cheek at this point).
Max
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of [EMAIL PROTECTED]
Sent: Monday, 1 March 1999 09:12
To: Multiple recipients of list delphi
Subject: Re: [DUG]: SQL Server or Interbase ??
I would allmost totally agree with Nic on this one.
We did an extensive comparision about a year ago between IB 5 and (beta) MS
SQL 7. In the end we chose IB cause we wanted to sleep at night. However,
it took until IB 5.5 before Interbase delivered on it's promise.
I still feel that MS SQL is better in a more general purpose or DSS/OLAP
role than IB and it probably handles huge databases better. Also MS's
optimizer is better. But for most small to medium size apps/db's - which
is what NZ's users generally are - IB wins every time.
Nic Wise <[EMAIL PROTECTED]> on 28/02/99 15:32:21
Please respond to [EMAIL PROTECTED]
To: Multiple recipients of list delphi <[EMAIL PROTECTED]>
cc: (bcc: Peter Jones/Logistics&Information
Technology/Christchurch/Foodstuffs)
Subject: Re: [DUG]: SQL Server or Interbase ??
> Hi all.
OK, I'm a little biased, but still..... (so are most people who have
used
IB)
>
> I have only really had experience with SQL Server, how does Interbase
> stackup against
> SQL server ?
Basically, except for a few points, it eats its lunch. Period.
> Is is reltivly similar ?
Kinda. Both are RDBMS's with SQL interfaces - a lot of the themes
are the same - SP's, Triggers etc. MSSQL has a nicer interface (UI),
and more built in SP's, but its tied to NT (NOT a good thing if
you need >100 people on the machine), and has a few fundermental
flaws (no row level locking, the log file, having to manually resize
data files (6.5), only one transaction per connection, only one active
statement per connection (this is a biggie), 16 tables per select)
Interbase has stuff all UI, but it doesn't need it (there is stuff all
to configure), it runs on various flavours of Unix as well as NT/9x
(and linux!!), and requires stuff all memory (64meg machine will run
WELL, not on MSSQL). It has pre and post triggers (ie, fire before an
insert,
not just after it!), and good SP language (not as good as PL/SQL, but
way better than Transact/SQL), etc.
Oh, and we sell it. :)
> Is it about the same in ease of use ?
>From a developer's POV using Delphi (different if you use VB or VC++),
I think they are about the same. Technically, dont start with IB if you
want to go back to MSSQL at a later date - it (MSSQL) will just
frustrate you
.
:)
> Is it easy to deploy ?
MSSQL is a MISSION to delpoy, especially in a single user system (ala
IBLocal),
and not a load of fun as a server.
Interbase is trivial to install and deploy. Just run the installer. Set
passwords
if needed. Put your DB on the machine. Leave it alone.
Embed, Deploy, Relax. I hate taglines, but this one is about right.
> Any info would helpful.
If you need something specific, drop me a line ([EMAIL PROTECTED]). I
have
done a few comparisons for people of late (I've used MSSQL for about a
year
at my previous job, from a dev. and admin point, and I have a MCP exam
for it under my belt), and I can forward them to you if you want them
Nic
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
