[DUG] Why InterBase

[Kyley Harris]

Well, I guess this is where it comes to personal preference to
development style. 

I may be repeating existing stuff here because I am reading and replying
to threads in order. 

I personally have opted to have all my business logic in a Middletier
approach and use the DB only for storage. 1 reason is the ease of moving
to another database, or even storing parts of the data into different
databases on different servers easily. It also means that I can manage
the scalability of my app better by connection pooling the database
access and managing resources. I have found that under normal app use 10
connections handled by the middle tier adequately support 20-40 users,
because most of the time data is readonly, and 20-40 users connecting
directly to any database with large amounts of active cursors is a
hungry beast.

It comes down to preference I think, and style of application.

-----Original Message-----
From: delphi-bounces at ns3.123.co.nz [mailto:delphi-bounces at ns3.123.co.nz]
On Behalf Of Rohit Gupta
Sent: Thursday, 1 June 2006 1:49 p.m.
To: NZ Borland Developers Group - Delphi List
Subject: RE: [DUG] Why InterBase

Then I am the odd one out.

We use stored procedures extensively,  With only 126 Tables, we have 400

procedures and 544 triggers.  Everytime we change something, we shift 
more business logic into the database.

We have to MSSQL for Web stuff and we prefer Firebird because Stored 
Procedures and Triggers work better for us.  In fact, there is no way we

could convert the database to FB now, without shifting a whole lot of
code 
back to the app.

Subject:        	RE: [DUG] Why InterBase
Date sent:      	Thu, 1 Jun 2006 07:14:33 +0800
From:           	"Richard Vowles" <Richard.Vowles at borland.com>
To:             	"NZ Borland Developers Group - Delphi List"
<delphi at ns3.123.co.nz>
Send reply to:  	NZ Borland Developers Group - Delphi List
<delphi at ns3.123.co.nz>
	<mailto:delphi-request at ns3.123.co.nz?subject=unsubscribe>
	<mailto:delphi-request at ns3.123.co.nz?subject=subscribe>

[ Double-click this line for list subscription options ] 

This is interesting - both Kylie and yourself have confirmed what I have
had experience - MS SQL's superior Stored procedure language wins out on
those who like to put a bit (or a lot) of code in the database engine.  

I'm not big on stored procedures, but that is probably because I focus
on InterBase and the stored procs are limited.

Richard
---
Richard Vowles, Solutions Architect, Borland New Zealand
email: richard.vowles at borland.com
phone: +64-9-9184573
cell: +64-21-467747
other: MSN richard.vowles at borland.com, skype: rvowles
blog: http://www.usergroup.org.nz/blogs/selectBlog.html?id=39769

-----Original Message-----
From: delphi-bounces at ns3.123.co.nz [mailto:delphi-bounces at ns3.123.co.nz]
On Behalf Of Jeremy Coulter
Sent: Thursday, 1 June 2006 12:04 a.m.
To: 'NZ Borland Developers Group - Delphi List'
Subject: RE: [DUG] Why InterBase

I used IB for about 6-7 months after going from MSSQL 7(this is like 6
years ago now), and HATED that IB didn't have a nice GUI interface. I
didn't like this whole "Domains" thing for variables, although I did see
the sense in it after a while and did use them, and REALLY hated having
to use some other DLL to get any decent functions to use when doing
Stored Procs.
When I left that job, after 6mths cos I hated the pace, and got my
current role which I have had for 6years now, I went back to MSSQL, and
now MSSQL
2005 is out, I REALLY like it !
I guess it's the old story of horses for courses. We do a LOT with
stored procs (well not so much me these days) and we are ready to start
getting in MSSQL 2k5 soon as we can.

_______________________________________________
Delphi mailing list
Delphi at ns3.123.co.nz
http://ns3.123.co.nz/mailman/listinfo/delphi
Regards

Rohit

======================================================================
CFL - Computer Fanatics Ltd.  21 Barry's Point Road, AKL, New Zealand
PH    (649) 489-2280 
FX    (649) 489-2290
email rohit at cfl.co.nz  or  r.gupta at xtra.co.nz
======================================================================


_______________________________________________
Delphi mailing list
Delphi at ns3.123.co.nz
http://ns3.123.co.nz/mailman/listinfo/delphi