From: marius p. <ma...@re...> - 2002-04-29 17:22:58
|
On Mon, 29 Apr 2002 08:48:22 -0400 <im...@yo...> wrote: > I am in need of some advice/help. We are planning on switching to IB or > Firebird as a replacement for SQL Server. I've spent the last week doing > some research on which version to use and which dev console to use. > I still have some questions to ask and I was wondering if there was anyone > who could help? > > I Have 3 main areas that I need help in. First, what are the pros and cons > of using IB 6 open source and Firebird? I have tried both and I've read > the paper on Firebird. It does seem to have some advantages, but is it as > or more reliable than IB 6? If I had to choose between the two I would have > to choose the reliability. Use the source luke :) (firebird) The firebird have the forced writes turned ON !!! the borland had thouse things turned OFF!!! .The speed was good on the borland part but if the electrical power goes off ,or the system is rebooted then YOUR DB MAY BE CORRUPTED (CRASHED). What is the difference between "certified" Borland version and the FireBird? Whell they should answer to that but from what i see from outside they do some extra testing there at borland but even so the Firebird runs a set of tests to (when they build the engine) Even at the MySql or Posgres they run some kind of internal tests . To sum up :use the version of the firebird that is stable enough and look at the bugs on sourceforge . Pay a developer to do a test :write a small application in delphi,perl,etc that stress the database one day or one week and do that from 2-10 computers .Put some fire in the firebird engine :) If the database is too big (2-10 gigs) split-it in smallers files (firebird is smart and there is a sql api for this when create the db) They did a smart stuff with the 64bit/IO that permits to increase the database file to the sizes greater than 2G. Don't know how it works(din't test it yet) how stable it is. Another think :use stored procedures everywere (they are precompiled ) and speeds up the queries . > Second, I've tried some demos for dev environments. QuickDesk, WorkBench, > and > IBExpert. Of the tree, I like QuickDesk but it seems to have a few bugs (?). > IBExpert and QuickDesk seem to be modeled form each other( what's up with > that?). > Which one came first? Anyway, again reliability is more important above the > bells and whistles. IBExpert is the good way (there is a personal edition) .You can do debugging on stored procedures http://www.hksoftware.net/download/ (The guy who did the QuickDesk has gone to another firm Hksoftware and took the source code with him so the IBExpert is the more mature product still) There is in the command line ISQL(in the interbase bin dir) and it does all the stuff the gui do but is to much hardwork and life is too short :( On the open source side i like IBAccess(www.ibaccess.org) is very basic but works > And lastly, we have a project that we are going to be switching over to one > of the two databases. The project currently uses SQL Server and I will need > to switch all of the objects over. I've read a lot of the documentation for > IB6 but I still have a few questions before I start to re-write all of this > code. If I put together a document of some questions, is there any one who > will help me with the answers? A Small comparision between firebird (ib) an mssql http://www.cvalde.com/document/comparison_ib6_mssql7.htm some good tools : http://www.ibphoenix.com/sql2gdb.html http://www.clevercomponents.com/ (here is the ib datapump i have used for a 1G+ database that was damaged ..it was a ib6.0 db..those things happen) > Thank You. > > Steve Downey > > IM...@vo... > > > > _______________________________________________ > Firebird-test mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-test |