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.

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

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]

"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

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

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

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