Yeah I agree - with most things programming no 100% correct answer. I prefer using database as solely datastore. The BO handles all the logic. The downside is the data layer can be a little heavier.
I use ADO.NET 2.0 datafactories so it means I can plug in any datastore just by changing a config file. But I can also see the worth of using the sp approach. The argument usually revolves around leaving the db stuff to a dba and the programming to a programmer. This is usually a us centric argument as not many projects in NZ would separate the roles? -----Original Message----- From: "Kyley Harris" <[EMAIL PROTECTED]> To: [EMAIL PROTECTED]; "NZ Borland Developers Group - Delphi List" <[email protected]> Sent: 1/06/06 19:29 Subject: RE: [DUG] Why InterBase 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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" <[EMAIL PROTECTED]> To: "NZ Borland Developers Group - Delphi List" <[email protected]> Send reply to: NZ Borland Developers Group - Delphi List <[email protected]> <mailto:[EMAIL PROTECTED]> <mailto:[EMAIL PROTECTED]> [ 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: [EMAIL PROTECTED] phone: +64-9-9184573 cell: +64-21-467747 other: MSN [EMAIL PROTECTED], skype: rvowles blog: http://www.usergroup.org.nz/blogs/selectBlog.html?id=39769 -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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 [email protected] 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 [EMAIL PROTECTED] or [EMAIL PROTECTED] ====================================================================== _______________________________________________ Delphi mailing list [email protected] http://ns3.123.co.nz/mailman/listinfo/delphi _______________________________________________ Delphi mailing list [email protected] http://ns3.123.co.nz/mailman/listinfo/delphi _______________________________________________ Delphi mailing list [email protected] http://ns3.123.co.nz/mailman/listinfo/delphi
