Admittedly vague question about speed

[Mike Purdy]

Do the multithreaded core features of v1.9 offer speed improvements over 1.8?

Also, Fred, are you still developing hxql?  (I believe that was the name of it..)


------------------------------------------------------------------------------
Come build with us! The BlackBerry® Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9-12, 2009. Register now!
http://p.sf.net/sfu/devconf
_______________________________________________
Hsqldb-user mailing list
Hsqldb-user@...
https://lists.sourceforge.net/lists/listinfo/hsqldb-user

[Fred Toussi-2]

Talking about simple operations which were already very fast in 1.8:

The main reason for multithreading is to allow queries to run in
parallel. Selects can take place simultanously without locking.

The multithreaded code offers speed improvements over 1.8 when used on
multicore computers with multiple simultaneous connections. This is
great for usage as backend for web sites and other information
resources.

Otherwise there is the overhead of the more sophisticated locking
mechanisms, which make 1.9 slightly slower than 1.8. This is largely
mitigated by improvements to cached table row access. So cached table
performance is sometimes faster, sometimes slower than 1.8.

For more complex operations, both queries and other statements, there
are new query optimisations which make statements with joins, or those
including IN and OR conditions run an order of magnitude faster. For
example, a query that took 10 seconds now takes 10 milliseconds.

I am still developing hxsql (the web site is at http://www.hxsql.com)
and the development code is in sync with HSQLDB 1.9. New versions will
be released shortly after the hsqldb version.

Fred

On Mon, 05 Oct 2009 12:59 -0400, "Mike Purdy"
<PurdyMi@...> wrote:

> Do the multithreaded core features of v1.9 offer speed improvements over
> 1.8?
>
> Also, Fred, are you still developing hxql?  (I believe that was the name
> of it..)
>
>
> ------------------------------------------------------------------------------
> Come build with us! The BlackBerry® Developer Conference in SF, CA
> is the only developer event you need to attend this year. Jumpstart your
> developing skills, take BlackBerry mobile applications to market and stay
> ahead of the curve. Join us from November 9-12, 2009. Register
> now!
> http://p.sf.net/sfu/devconf
> _______________________________________________
> Hsqldb-user mailing list
> Hsqldb-user@...
> https://lists.sourceforge.net/lists/listinfo/hsqldb-user

------------------------------------------------------------------------------
Come build with us! The BlackBerry® Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9-12, 2009. Register now!
http://p.sf.net/sfu/devconf
_______________________________________________
Hsqldb-user mailing list
Hsqldb-user@...
https://lists.sourceforge.net/lists/listinfo/hsqldb-user