[EMAIL PROTECTED] says...
> I had to choose some time ago, but lets go: > Firebird/Interbase cannot be used by mine projects > since max lenght of an index is (or was) 254 bytes > (imagine if you need to index 2 fields with 128 > char unicode, or an timestamp + varchar(250) > - it's impossible). Why on earth would you want to index on 2 fields with 128 chars? This strikes me as bizarre! > May be latest releases of Firebird/Interbase solved > this limitations, but I really don't search news > since then. > I've kicked out Interbase 6 from my workstation > to work with SapDB (7.2 in that time). > And at that time, Java support was poor (I've > contributed with Interbase java driver, but they > never published a new binary release, so I needed > to maintain myself - something that is not > interesting). I would have to agree that the support for interfaces such as Java, perl and others is somewhat lacking, but I believe that a big push has been made on the Java side of things. Connectivity to Borland's developement tools is excellent. > I'll suggest you to check item by item in > capabilities of two databases... You will be safe > from surprises in the future. > Check mailing lists for known bugs... And > difficulties that developers are facing... > The two databases has a "dark side" (the SapDB > one - IMHO - is that sometimes is hard to do > admin tasks - hey, don't blame me: at least > is not so easy as Interbase or MS SQL), but I > think that Interbase has they dark side too (I've > seen several corrupted databases, the java support > was poor, no/poor ADO support, only commercial ODBC > support and so on). These corrupted dbs - what sort of server(s) were they on? UPS? Raid? I have read complaints from people on Borland's newsgroups who are surprised when a non-UPS Wintendo 98 box that they were using as their db server gets corrupted! > SapDB has evoluted in admin tools - check WebDBM, > that is great! I agree that SAP's admin and other tools are way better than interbase or firebird. > I'm not firing Interbase, neither Firebird, neither > SapDB. Fine. > I just choosen SapDB because the large data volumn > support (larger databases, Interbase/Firebird can manage large dbs - hundreds of GB! > transaction log, Interbase/Firebird has a versioning system architecture which means that you don't need a transaction log, at least AIUI. > multiprocessor, This is very close in Firebird - I believe that commercial editions of Interbase now do it well. > multiplataform, Firebird works on lots of platforms. Windoze, Linux, FreeBSD, MAC OSX, Darwin, HP UX, AIX (I think), SINIX, Solaris.... > great number of connections), Interbase can cope with 100's of users. > and their interfaces (ODBC and JDBC) - that really > work, I agree that IB/FB falls down in this regard. > and finally, because support mail lists is real > cool (congratulations Sap guys - and girls ;-) ) ! The support on the Borland newsgroups is excellent, as is the support on the Firebird lists/groups. Paul... > Edson Richter -- plinehan__AT__yahoo__DOT__com ___________________________________________________________ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en fran�ais ! Yahoo! Mail : http://fr.mail.yahoo.com _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
