Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 7 of 7 total |
V5 with fast SQL? |
Wed, Oct 6 2010 12:42 PM | Permanent Link |
Michael Fullerton | Will there ever be a DBISAM 5 with faster SQL? I know there's EDB but
I much prefer DBISAM. Even if there was a new product with the simplicity of DBISAM and the speed of EDB. |
Wed, Oct 6 2010 2:18 PM | Permanent Link |
Raul Team Elevate | Michael Fullerton wrote:
> Will there ever be a DBISAM 5 with faster SQL? I know there's EDB but > I much prefer DBISAM. Even if there was a new product with the > simplicity of DBISAM and the speed of EDB. Tim is the final authority but based on what he has said in the past there will not be a DBISAM 5. Current version is being maintained though, including optimizations and fixes so if you could elaborate on what you mean by "faster SQL" i'm sure he would take a look. Are you taking about specific issue you're running into or statements that you need to run faster? Raul |
Thu, Oct 7 2010 3:42 AM | Permanent Link |
Chris Holland SEC Solutions Ltd. Team Elevate | Is EDB that much faster than DBISAM?
I ran some tests comparing the two about a yar ago and in my application there was no real difference. Has EDB has improved in speed since then? If so I may have to think about switching over. (Unless there is goinfg to be a DBISAM 5 as I have no need of RI, triggers, etc. and love the simplicity of DBISAM as well) Chris Holland On 06/10/2010 17:42, Michael Fullerton wrote: > Will there ever be a DBISAM 5 with faster SQL? I know there's EDB but > I much prefer DBISAM. Even if there was a new product with the > simplicity of DBISAM and the speed of EDB. > -- Chris Holland [Team Elevate] |
Thu, Oct 7 2010 4:01 AM | Permanent Link |
Farshad Mohajeri | "Michael Fullerton" . > Will there ever be a DBISAM 5 with faster SQL? I know there's EDB but > I much prefer DBISAM. Even if there was a new product with the > simplicity of DBISAM and the speed of EDB. > If there's going to be a V5, here is my humble(!) wishlist: 1) Single file DB 2) Unicode support Regards, Farshad |
Thu, Oct 7 2010 7:28 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Chris
It may not be faster (haven't tested so don't know) in simple operations, but one of the prime drivers in me sticking with it was the massive improvement on full text indexing performance. Roy Lambert |
Thu, Oct 14 2010 1:33 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Michael,
<< Will there ever be a DBISAM 5 with faster SQL? >> No, there won't be a DBISAM 5. << I know there's EDB but I much prefer DBISAM. Even if there was a new product with the simplicity of DBISAM and the speed of EDB. >> I'm not sure if you caught this feature in 2.04, but you can now use "virtual" (in-memory) configurations with ElevateDB, meaning that you can deploy ElevateDB in a similar manner as DBISAM - database catalog and table files only, with no on-disk configuration file. -- Tim Young Elevate Software www.elevatesoft.com |
Thu, Oct 14 2010 1:41 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Chris,
<< Is EDB that much faster than DBISAM? >> ElevateDB has had quite a few performance optimizations over the last year or so, so you might want to take another look. Some of the major improvements have been with : 1) Set handling with very large tables - ElevateDB can now handle WHERE/JOIN filtering on very large tables (4+million rows) much quicker now. 2) ALTER TABLE performance improvements - ElevateDB is now much more selective about how it processes ALTER TABLE statements, and can perform column additions very quickly. 3) Concurrent session connections/disconnections on the ElevateDB Server - ElevateDB can now handle hundreds of connections/disconnections per second on the server. 4) Parsing/compiling statements/procedures - ElevateDB has a much-improved parsing/compilation phase for statements and procedures that allow it to do faster symbol lookups. 5) REPAIR/VERIFY TABLE - ElevateDB now has multi-level repair/verify facilities that can verify a table while it is on-line, and in only a few seconds (structural verification). <<Unless there is goinfg to be a DBISAM 5 as I have no need of RI, triggers, etc. and love the simplicity of DBISAM as well) >> Just remember - those features don't consume any processing time with ElevateDB if you don't use them, so they are simply something that you can ignore if you don't need them. Also, per my response to Michael - ElevateDB 2.04 can now use virtual configurations, so you can deploy ElevateDB in a manner similar to DBISAM (just catalog and table files). See here for more information: http://www.elevatesoft.com/manual?action=viewprop&id=edb2&product=d&version=7&comp=TEDBEngine&prop=ConfigMemory -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Tuesday, April 30, 2024 at 03:55 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |