BorlandTalk.com Borland discussion newsgroups   Archives   FAQ   Search   Memberlist   Usergroups   Register   Profile   Log in to check your private messages   Log in  dbexpress vs ADO          BorlandTalk.com Forum Index -> Delphi Databases (dbExpress) View previous topic :: View next topic   Author Message Alex.K Guest Posted: Fri Apr 27, 2007 11:56 pm    Post subject: dbexpress vs ADO Hello, We have upgraded from D5 to D2007 and want to replace the BDE. We develop and sell document management software. We currently have over 500 clients. By default our single user version uses Paradox tables ( ~80% of our sells ). We offer Client/Server solutions and in those cases, many of the installations in place are using MSSQL or Oracle ( ~20% of our sells ). We also provide trial versions of our SUV's. So what ever solution we select, we will need to provide a seamless installation package that does not require any assistance from us. Being that we are new to dbexpress and ADO, what are the pros and cons of each and which one would provide us with a more solid solution. ( deployment, support, cost, etc... ) TIA, - Craig Back to top Esteban Pacheco Guest Posted: Tue May 01, 2007 6:29 am    Post subject: Re: dbexpress vs ADO If you are doing deployments to multiple databases I will recommend dbexpress, if it were only MSSQL i will tend to go with ADO, what is my issue with the latest one, ADO is no longer improved by MS. DbExpress offers forward only cursors, which in combination with TClientDatasets offers a faster solution than ADO, aslo there is ongoing development on the CodeGear side and from third party vendors around it looking always to improve it. DBX4 offers a single code development for win32 and .net which will help lots when and if you ever had the need to provide a .net version. We currently only support ADO, but we will be migrating to DBX4 to increase our flexibility to plug our software to other databases such as FireBird, PostSQL, and MySQL which are inexpensive solutions for our clients. More things can be say, but i will leave that to fellow posters. Att. Esteban Pacheco A Delphi Programming Blog http://blogs.epachsoft.com "Alex.K" <nomail (AT) nomail (DOT) com> wrote in message news:46324753$1 (AT) newsgroups (DOT) borland.com... Quote: Hello, We have upgraded from D5 to D2007 and want to replace the BDE. We develop and sell document management software. We currently have over 500 clients. By default our single user version uses Paradox tables ( ~80% of our sells ). We offer Client/Server solutions and in those cases, many of the installations in place are using MSSQL or Oracle ( ~20% of our sells ). We also provide trial versions of our SUV's. So what ever solution we select, we will need to provide a seamless installation package that does not require any assistance from us. Being that we are new to dbexpress and ADO, what are the pros and cons of each and which one would provide us with a more solid solution. ( deployment, support, cost, etc... ) TIA, - Craig Back to top Alex.K Guest Posted: Tue May 01, 2007 9:03 pm    Post subject: Re: dbexpress vs ADO Hello Esteban, Thank you for the information... I look forward to hear other opinions. - Craig "Esteban Pacheco" <pythiasoftware (AT) yahoo (DOT) com> wrote in message news:463697a4$1 (AT) newsgroups (DOT) borland.com... Quote: If you are doing deployments to multiple databases I will recommend dbexpress, if it were only MSSQL i will tend to go with ADO, what is my issue with the latest one, ADO is no longer improved by MS. DbExpress offers forward only cursors, which in combination with TClientDatasets offers a faster solution than ADO, aslo there is ongoing development on the CodeGear side and from third party vendors around it looking always to improve it. DBX4 offers a single code development for win32 and .net which will help lots when and if you ever had the need to provide a .net version. We currently only support ADO, but we will be migrating to DBX4 to increase our flexibility to plug our software to other databases such as FireBird, PostSQL, and MySQL which are inexpensive solutions for our clients. More things can be say, but i will leave that to fellow posters. Att. Esteban Pacheco A Delphi Programming Blog http://blogs.epachsoft.com "Alex.K" <nomail (AT) nomail (DOT) com> wrote in message news:46324753$1 (AT) newsgroups (DOT) borland.com... Hello, We have upgraded from D5 to D2007 and want to replace the BDE. We develop and sell document management software. We currently have over 500 clients. By default our single user version uses Paradox tables ( ~80% of our sells ). We offer Client/Server solutions and in those cases, many of the installations in place are using MSSQL or Oracle ( ~20% of our sells ). We also provide trial versions of our SUV's. So what ever solution we select, we will need to provide a seamless installation package that does not require any assistance from us. Being that we are new to dbexpress and ADO, what are the pros and cons of each and which one would provide us with a more solid solution. ( deployment, support, cost, etc... ) TIA, - Craig Back to top Dan Downs Guest Posted: Wed May 09, 2007 8:44 pm    Post subject: Re: dbexpress vs ADO I currently use ADO to connect to SQL Server 2000, but have been doing some simple benchmarks to see if switching to DBX4 would be worthwhile. Here's my results so far, I'm using connection pooling with DBX4 for all these since ADO already has it built in, all results in seconds: Open/Close 1000 connections: DBX4: 0.551 ADO: 0.213 Open/Scan through/Close Query 1000 times: DBX4: 4.592 ADO: 13.174 Open/Scan through/Close StoredProc 100 times: DBX4: 2.197 ADO: 4.222 All results are done from within my VM, and I'm still trying to tweak settings to find the best mix. Since DBX4 connects slower I wanted to see if the faster query and storeproc times would out weight the connection time, so I added the following to my test program. Open connection/Open & Scan & Close Query/Open & Scan & Close StoredProc/Close Connection 100 times: DBX4: 2.973 ADO: 5.889 So far for me, its looking worthwhile to switch. DD Back to top Alex.K Guest Posted: Wed May 09, 2007 9:49 pm    Post subject: Re: dbexpress vs ADO Thanks Dan! "Dan Downs" <ddowns (AT) nospam (DOT) online-access.com> wrote in message news:4641ec54$1 (AT) newsgroups (DOT) borland.com... Quote: I currently use ADO to connect to SQL Server 2000, but have been doing some simple benchmarks to see if switching to DBX4 would be worthwhile. Here's my results so far, I'm using connection pooling with DBX4 for all these since ADO already has it built in, all results in seconds: Open/Close 1000 connections: DBX4: 0.551 ADO: 0.213 Open/Scan through/Close Query 1000 times: DBX4: 4.592 ADO: 13.174 Open/Scan through/Close StoredProc 100 times: DBX4: 2.197 ADO: 4.222 All results are done from within my VM, and I'm still trying to tweak settings to find the best mix. Since DBX4 connects slower I wanted to see if the faster query and storeproc times would out weight the connection time, so I added the following to my test program. Open connection/Open & Scan & Close Query/Open & Scan & Close StoredProc/Close Connection 100 times: DBX4: 2.973 ADO: 5.889 So far for me, its looking worthwhile to switch. DD 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 (dbExpress) 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.