| Author |
Topic |
|
harshal_in
Aged Yak Warrior
633 Posts |
 Posted - 2003-05-02 : 12:44:22
|
| Hi,Does anybody have any Idea about firebird (interbase) database?I had visited their site and they are saying all good things about it.It supports stored procs,triggers,unicode jobs etc.My boss has also mentioned that it can go with out a dba maintaining it :(we are thinking of using it in one of our applications .these are all the good things about it ,does any one know about any reasons why we should not go for it (except it does not require a dba ,this is the only reason i found :))any advice appreciated.Regards,Harshal.Expect the UnExpected |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-05-02 : 13:25:59
|
| >> it can go with out a dba maintaining it?Really?Presumably the database grows automatically then - what happens when it runs out of disk space.Maybe it doesn't need much maintenance.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
harshal_in
Aged Yak Warrior
633 Posts |
Posted - 2003-05-03 : 00:57:18
|
| >> Maybe it doesn't need much maintenance.Yes that what those people are saying .It doesn't have any log file as such.only one data file which goes on incereasing.we can not take incremental backups only full backups are possible.there is a shadow file ,in case of crash.Anyone with any other info? I really don't know why this database is not at all talked about though it comes free!any inputs apreciated.Regards,Harshal.Expect the UnExpected |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-05-03 : 08:30:04
|
| Well, everything they're saying about it (no dba, less admin) is equally true of MS Access, dBase, FoxPro and the like, which are older database technologies and hardly powerful enough for a heavy production environment. I wouldn't take the company's word as gospel either, of course they're going to talk up the product and make it look as good as possible. Just remember the old phrase, "You get what you pay for" and remember that this software is free...On another extremely important note, what is their support like? |
|
|
|
harshal_in
Aged Yak Warrior
633 Posts |
Posted - 2003-05-05 : 01:52:39
|
quote:
Well, everything they're saying about it (no dba, less admin) is equally true of MS Access, dBase, FoxPro and the like, which are older database technologies and hardly powerful enough for a heavy production environment. I wouldn't take the company's word as gospel either, of course they're going to talk up the product and make it look as good as possible. Just remember the old phrase, "You get what you pay for" and remember that this software is free...On another extremely important note, what is their support like?
I absolutely agree with what you are saying rob,but with these points I won't be able to debate with the management ,these are all the points which we people will agree but I need some very strong poits which I can state to the management.It would be very helpfull if I get those inputs.Thanks Rob.Regards,Harshal.Expect the UnExpected |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-05-09 : 16:50:10
|
| Yeah,How about what are their benchmarks?How fast can the load /unload dataWhat about security?How does it handle parallelism (does it even)?Can it handle partitioned views?have some fun, take 2 boxes side by side, and load the shit out of them. make serveral level a relationships, generate lots of data...and go nuts.Brett8-) |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
Arnold Fribble
Yak-finder General
1961 Posts |
Posted - 2003-05-09 : 17:23:06
|
| So how many open bugs are there in SQL Server? |
|
|
|
harshal_in
Aged Yak Warrior
633 Posts |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2003-05-11 : 00:02:46
|
| Harshal, if the big draw is that it's "free" then why not talk to them about MSDE instead? I think you'll need to help them understand that no database is maintenance-free (or "needs no DBA"). Who does the backups? Who does upgrades? Who deals with it when it breaks? Isn't that person acting as the production DBA for that database?I would think that you could setup MSDE to be run with little attention as anything else out there, and have the added benefit that it's a system you know, has logs, can be backed up, etc., etc. After all, it's a mini SQL Server. Oh, and as Brett mentioned, there's security.I suggest you seriously ask the inverse question: What does Firebird give us that we can't accomplish with MSDE? and let somebody justify why you should introduce a new technology rather than assuming the new technology will be used and you have to argue why it's a bad idea.------------------------------------------------------The more you know, the more you know you don't know. |
|
|
|
harshal_in
Aged Yak Warrior
633 Posts |
Posted - 2003-05-11 : 15:21:50
|
quote:
Harshal, if the big draw is that it's "free" then why not talk to them about MSDE instead? I think you'll need to help them understand that no database is maintenance-free (or "needs no DBA"). Who does the backups? Who does upgrades? Who deals with it when it breaks? Isn't that person acting as the production DBA for that database?I would think that you could setup MSDE to be run with little attention as anything else out there, and have the added benefit that it's a system you know, has logs, can be backed up, etc., etc. After all, it's a mini SQL Server. Oh, and as Brett mentioned, there's security.I suggest you seriously ask the inverse question: What does Firebird give us that we can't accomplish with MSDE? and let somebody justify why you should introduce a new technology rather than assuming the new technology will be used and you have to argue why it's a bad idea.------------------------------------------------------The more you know, the more you know you don't know.
hi ajarn,you are absolutely right we had tried MSDE we had two most important issues with it the firstone being that it does not support multiple concurrent users say above 15 ,it becomes terribly slow or does not respond at all.the second is about the overhead of the size ,here I am not quite sure but the total package comes in about 70 mb out of which the required modules come out to be around 20 mb,if we plan to embed the database server in the application the overall size of the application goes very high compared to firebird which comes in about 3.0 mb  (the whole thing).And it is redistrubutable.:(Expect the UnExpected |
|
|
|
|
Firebird database
Expect the UnExpected