I've used Interbase for many years before switching</patronising>
to sapdb and I've found it to be a cute little
database
Not at all, Interbase/firebird is both cute and little, I love the way you can move the entire database by moving a single file and that you can install the DBMS on any windows machine by copying aroudn 10 files and running the database server.
Sapdb is not cute nor little, it is a big-ass database that eats small sysadmins for lunch, but it scales much further up than IB, IB does not know how to take advantage of multible drives not does it do anything interesting with more than one CPU when executing a single query (AFAIR).
I don't think Interbase would do well if you had more data than could fit in RAM, but it would be very interesting to see someone get SAP R/3 running on IB.
This is interesting, because I've written multi-user apps with IB and have never had a problem
Well, you probably didn't use the perl interface, if the database is useless from the perl interface then it's simply wothless to me.
sapdb is very easy to use, but it can be very, very hard to set up.
I have found this!
It does pay off in the end, when the backup procedures have been automated there is little or no maintainance work to do to sapdb.
Same goes for IB/FB.
Well, until you start hitting strange bottlenecks that noone has ever seen before because it is normally used in single user / low load situations, however this mostly happens when you have more data than the system can cache in RAM as long as everything is in RAM all databases perform the same, the real test of DBMS smarts comes when it's important to be smart about IO.
So, it might very well be that InterBase/Firebird is the best, Free allround SQL DBMS for databases tiny enough to fit in RAM and these days that typically means 2GB so if you have small amounts of data go ahead and use IB.
-- Regards Flemming Frandsen - http://dion.swamp.dk PartyTicket.Net co founder & Yet Another Perl Hacker
_______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
