At work, we us VB(agh puke puke !!!) and SQL Server 7 and I must admit, I
find it quite slow compared to SQL Server 6.5.....and its not just me.....it
might be a configuration thing, but then is it ment to be "Smart" when it
decides how much mem. it uses etc.
I had a play with interbase last night, but I couldn't see how to create
table, and when I tried to connect to a database, it gave some sort of
error.....its a shame it doesn't have a nicer interface, it would prob. make
people less scard of it, and less confused....BUT I intend to persevair with
it all the same......I get stuck in the Microsoft world at work, and based
on their last few releases, thats a BAD thing.
Thanks, Jeremy Coulter
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> Behalf Of Max Renshaw-Fox
> Sent: Monday, March 01, 1999 22:47
> To: Multiple recipients of list delphi
> Subject: RE: [DUG]: SQL Server or Interbase ??
>
>
> 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
>
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
