BorlandTalk.com Borland discussion newsgroups   Archives   FAQ   Search   Memberlist   Usergroups   Register   Profile   Log in to check your private messages   Log in  What database to use?          BorlandTalk.com Forum Index -> Delphi Databases (SQL Servers) View previous topic :: View next topic   Author Message Bruno Lovatti Guest Posted: Fri Apr 22, 2005 12:52 pm    Post subject: What database to use? Hi! We use Microsoft SQL Server for the main server and databases, works very well and stable, the biggest database has 45GB of data and no corruption. We're starting another project that will have a database starting with 70GB, this is because we are importing the data from text files, a lot of them. This project will run in another server (Pentium 4 3.0 Ghz with 1GB of ram and SATA disks) because we don't want to slowdown the main server. We want a free database as we will not buy another SQL license and it is a chance to evaluate free solutions. The features most required are: - big size of db (70 - 150 GB) - runs on windows 2003 - stable - fast - realiable - SQL - delphi connectivity I found Firebird, PostgreSQL, Ingres, MySQL. Any comments on these databases? Any other suggestion? Thanks! Bruno Back to top Crazy Horse's crazier lit Guest Posted: Fri Apr 22, 2005 2:25 pm    Post subject: Re: What database to use? "Bruno Lovatti" <blovatti(remove this)@terra.com.br> wrote Quote: Any comments on these databases? Any other suggestion? We have legacy MySQL (and Progress) tables here, but all our new development is in Firebird. I have no complaints about Firebird--there are no limitations that I've come across, and when used together with Database Workbench (from upscene), it's about as painless as you can get. My preferences (of the databases I've used): Firebird Interbase DBISAM MS SQL Server Paradox dBase Access Oracle -- Download Blackbird Crow Raven's book "STILL CASTING SHADOWS: Two American Families 1620-2006" (.exe and Delphi source): http://cc.borland.com/ccweb.exe/listing?id=23106 Back to top Eduardo A. Salgado Guest Posted: Fri Apr 22, 2005 2:35 pm    Post subject: Re: What database to use? For a *FREE* database I would recommend Firebird. See my comments on Re: Finally dumping BDE. Our biggest database is only about 6.5 GB but I have read of larger ones in The Firebird Book by Borrie. We develop in Delphi and run on W2K and all the "Server" versions. - Eduardo It took me seventeen years to get 3,000 hits in baseball. I did it in one afternoon on the golf course. -- Hank Aaron Eminent Domain Software "Custom Software Development For Your Domain" Makers of EDSSpell, EDSPrint, EDSZipCodes and XSpell, the IDE Expert. Bruno Lovatti wrote: Quote: We're starting another project that will have a database starting with 70GB, this is because we are importing the data from text files, a lot of them. This project will run in another server (Pentium 4 3.0 Ghz with 1GB of ram and SATA disks) because we don't want to slowdown the main server. We want a free database as we will not buy another SQL license and it is a chance to evaluate free solutions. The features most required are: - big size of db (70 - 150 GB) - runs on windows 2003 - stable - fast - realiable - SQL - delphi connectivity Back to top Bruno Lovatti Guest Posted: Fri Apr 22, 2005 4:28 pm    Post subject: Re: What database to use? I prefer to use Firebird, i've used it in another small project and it has nice components for Delphi, the problem is: will Firebird handle 70 - 150 GB databases without problems? i need it to be stable and fast. Thanks! Bruno Back to top Aage Johansen Guest Posted: Fri Apr 22, 2005 6:20 pm    Post subject: Re: What database to use? Bruno Lovatti wrote: Quote: I prefer to use Firebird, i've used it in another small project and it has nice components for Delphi, the problem is: will Firebird handle 70 - 150 GB databases without problems? i need it to be stable and fast. I think you will be all right with Firebird. If you haven't yet visited the Firebird NGs, see: http://www.firebirdsql.org/index.php?op=lists If you post your requirements on their support group I think you'll get fair advice on suitability. -- Aage J. Back to top Hannes Danzl[NDD] Guest Posted: Fri Apr 22, 2005 8:24 pm    Post subject: Re: What database to use? Quote: I found Firebird, PostgreSQL, Ingres, MySQL. Any comments on these databases? Any other suggestion? NexusDB can handle this easily :) -- Hannes Danzl [NexusDB Developer] Newsgroup archive at http://www.tamaracka.com/search.htm Back to top a Guest Posted: Sat Apr 23, 2005 12:47 am    Post subject: Re: What database to use? Bruno, Quote: We use Microsoft SQL Server for the main server and databases, works very well and stable, the biggest database has 45GB of data and no corruption. Then you should strongly consider sticking with a single database. Remember, you need to set-up, back-up, test, have a restoration plan, administer, etc. any new database. You are also going to need some absolutely monster backup systems for this. Finally, you'll need to be programming to another database. The cost of the extra SQL Server license will be nothing compaired to the added costs of setting-up, developing, and learning the new system. Let's say it only takes an extra 15 hours (ha, ha,...) to learn to install the new system (over MS SQL). Assume it only takes another extra 15 hours to familiarize yourself with backups, restoring databases, recovery plans, etc. Add another 15 hours extra learning how to program against it. Finally, assume over the next 2 year, you only one person on the project gets replaced and you need another 15 hours retrain them on the second DB operation. That is 45 extra hours at $20/hour = the cost of a second MS SQL DB. Companies have database standards for a reason. You can look at MSDN or personal licenses depending upon the set-up, but an additional server license is cheap compaired to the cost of familiaring yourself and maintaining any new product. Quote: We're starting another project that will have a database starting with 70GB, this is because we are importing the data from text files, a lot of them. This project will run in another server (Pentium 4 3.0 Ghz with 1GB of ram and SATA disks) because we don't want to slowdown the main server. We want a free database as we will not buy another SQL license and it is a chance to evaluate free solutions. The features most required are: - big size of db (70 - 150 GB) - runs on windows 2003 - stable - fast - realiable - SQL - delphi connectivity I found Firebird, PostgreSQL, Ingres, MySQL. Any comments on these databases? Any other suggestion? Thanks! Bruno Back to top Stig Johansen Guest Posted: Sat Apr 23, 2005 4:47 am    Post subject: Re: What database to use? Bruno Lovatti wrote: Quote: I found Firebird, PostgreSQL, Ingres, MySQL. Any comments on these databases? Any other suggestion? Take a look on MaxDB (Former SapDB): <http://www.mysql.com/products/maxdb/> -- Best regards Stig Johansen Back to top Aage Johansen Guest Posted: Sat Apr 23, 2005 1:41 pm    Post subject: Re: What database to use? a wrote: Quote: Bruno, We use Microsoft SQL Server for the main server and databases, works very well and stable, the biggest database has 45GB of data and no corruption. Then you should strongly consider sticking with a single database. Remember, you need to set-up, back-up, test, have a restoration plan, administer, etc. any new database. You are also going to need some absolutely monster backup systems for this. Finally, you'll need to be programming to another database. The cost of the extra SQL Server license will be nothing compaired to the added costs of setting-up, developing, and learning the new system. Let's say it only takes an extra 15 hours (ha, ha,...) to learn to install the new system (over MS SQL). Assume it only takes another extra 15 hours to familiarize yourself with backups, restoring databases, recovery plans, etc. Add another 15 hours extra learning how to program against it. Finally, assume over the next 2 year, you only one person on the project gets replaced and you need another 15 hours retrain them on the second DB operation. That is 45 extra hours at $20/hour = the cost of a second MS SQL DB. a, he already knows Firebird. Maybe he will even save a few hours by using Fb. -- Aage J. Back to top Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First         BorlandTalk.com Forum Index -> Delphi Databases (SQL Servers) All times are GMT Page 1 of 1   Jump to: Select a forum C++ Builder Newsgroups----------------C++ BuilderC++ Builder (ActiveX)C++ Builder (Announcements)C++ Builder (Command Line Tools)C++ Builder DatabasesC++ Builder Databases (ADO)C++ Builder Databases (Desktop)C++ Builder Databases (InterBase Express)C++ Builder Databases (Multi-Tier)C++ Builder Databases (SQL Servers)C++ Builder (Graphics)C++ Builder (IDE)C++ Builder (Internet)C++ Builder (Internet Socket)C++ Builder (Internet Web)C++ Builder (Jobs)C++ Builder (Language)C++ Builder (Language C++)C++ Builder (Compatibility with MFC)C++ Builder (Native API)C++ Builder (Non-Technical)C++ Builder (Students)C++ Builder (Third Party Tools)C++ Builder (Upgrade)C++ Builder (VCL)C++ Builder (VCL Components Usage)C++ Builder (VCL Components Development)C++ Builder (VCL Usage)C++ Builder (WinAPI)C++ Builder Installation Delphi Newsgroups----------------Delphi (General)Delphi ActiveX Controls UsageDelphi ActiveX Controls DevelopmentDelphi As400Delphi DatabasesDelphi Databases (ADO)Delphi Databases (dbExpress)Delphi Databases (Desktop)Delphi Databases (InterBase Express)Delphi Databases (Multi-Tier)Delphi Databases (SQL Servers)Delphi DeploymentDelphi GraphicsDelphi IDEDelphi InternationalizationDelphi InternetDelphi Internet Isapi-WebBrokerDelphi Internet WebSnapDelphi Internet WinsockDelphi JobsDelphi Language BASMDelphi Language ObjectPascalDelphi Model Driven Architecture (General)Delphi Model Driven Architecture (Third Party)Delphi MultimediaDelphi Native APIDelphi Non-TechnicalDelphi ObjectPascalDelphi OLE AutomationDelphi OO designDelphi OpenToolsAPIDelphi Reporting-ChartingDelphi RTLDelphi StudentsDelphi TeamSourceDelphi Thirdparty ToolsDelphi Thirdparty Tools (General)Delphi Thirdparty Tools (IntraWeb)Delphi Thirdparty Tools (RaveReports)Delphi UpgradeDelphi VCLDelphi VCL ComponentsDelphi VCL Components UsingDelphi VCL Components WritingDelphi WebServices SOAPDelphi WinAPIDelphi XMLDelphi Installationcomp.lang.pascal.delphi.components.misccomp.lang.pascal.delphi.components.usagecomp.lang.pascal.delphi.components.writingcomp.lang.pascal.delphi.databasescomp.lang.pascal.delphi.misccomp.sources.delphi JBuilder Newsgroups----------------JBuilderJBuilder AnnouncementsJBuilder Applet IssuesJBuilder As400JBuilder CompilerJBuilder CORBA/RMIJBuilder DatabasesJBuilder DB SwingJBuilder DebuggerJBuilder DeploymentJBuilder DocumentationJBuilder EnterpriseJBuilder HandheldJBuilder IDEJBuilder JavaJBuilder JavaAPIJBuilder Java LanguageJBuilder Java SwingJBuilder Java BeansJBuilder Java Beans UsageJBuilder Java Beans DevelopmentJBuilder JBCLJBuilder JDataStoreJBuilder JobsJBuilder LinuxJBuilder MacintoshJBuilder & MobileSetJBuilder MultiLingual AppsJBuilder Non-TechnicalJBuilder OpenToolsJBuilder Servlets (JSP)JBuilder StudentsJBuilder Team DevelopmentJBuilder Thirdparty ToolsJBuilder UpgradeJBuilder Installation InterBase Newsgroups----------------InterBaseInterBase Bug DiscussionInterBase GeneralInterBase IBConsoleInterBase OpenSourceInterBase ReplicationInterBase SQLInterBase ThirdpartyInterBase Installation Miscellaneous Borland Newsgroups----------------AppCenterAppServerEnteraVisiBroker  You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum Powered by phpBB © 2001, 2006 phpBB Group SEO toolkit © 2004-2006 webmedic.