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
