Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 1 to 3 of 3 total

any DBISAM vs ElevateDB speed comparison available?

Fri, May 16 2008 2:14 PM	Permanent Link
=?iso-8859-1?Q?Luis_Concepci=F3n?=	Hi! Is there any speed comparison available between ElevateDB and DBISAM? I remember some 'Paradox vs Access' or 'DBISAM vs Firebird', etc... speed comparison charts long time ago? Anybody that have made speed comparisons with both products? Thanks!
Sat, May 17 2008 12:51 PM	Permanent Link
"Terry Swiers"	Luis, > Anybody that have made speed comparisons with both products? My manual testing and comparison between the two indicates that in general EDB is faster than DBISAM or at a minimum as fast as DBISAM. I've not done a whole lot of testing on updates, but those do appear to be quite a bit faster especially when working with large tables. Where I see the most performance difference is in the client/server connection data retrieval back to the local client. Running DBISAM and EDB against the same data on a remote connection across the internet, DBISAM is rather sluggish when scrolling through the data where EDB is almost as fast as having the data on a local server. I know that this is just a general observation, but thought I would through my 2 cents out since no one else has responded. -- --------------------------------------- Terry Swiers Millennium Software, LLC http://www.1000years.com http://www.atrex.com Atrex Inventory Control/POS - Big business features without spending big business bucks! Atrex Electronic Support Options: Atrex Knowledgebase: http://www.atrex.com/atrexkb.asp Email: mailto:support@atrex.com Newsgroup: news://news.1000years.com/millennium.atrex Fax: 1-925-829-1851 Phone: 1-925-828-5892 (M-F, 9a-5p Pacific) ---------------------------------------
Sun, May 18 2008 12:17 AM	Permanent Link
"David Cornelius"	I have not done any comparison testing. But there's one aspect of EDB over DBISAM that has led me to write faster code! While DBISAM supports "stored procedures" the process of getting a new stored procedure into a client/server database is quite involved and requires shutting down the server, installing the new version, starting it back up, then assigning the new routines to a user for access. I ended up writing very few of these and only in the most necessary cases. However, with SQL-based stored procedures, the pain is gone! In a recent application, I decided to move a certain process that involved sets of SQL statements previously in Delphi components to stored procedures, just to have less database code in the application. I briefly thought about a possible speed increase but it wasn't the main goal. After doing so however, not only was the speed noticably increased for this particular process, but a bug that had been eluding me was gone as well! I suppose it was cleaner code or re-thought code or something, but I know that this one feature of SQL-based stored procedures that can be created and edited right in the EDB Manager and executed immediately has alone been well worth the upgrade for me. -- David Cornelius CorneliusConcepts.com custom designed software Luis Concepción wrote: > Hi! > > Is there any speed comparison available between ElevateDB and DBISAM? > I remember some 'Paradox vs Access' or 'DBISAM vs Firebird', etc... > speed comparison charts long time ago? Anybody that have made speed > comparisons with both products? > > Thanks!