[elephant-devel] Re: Severely poor performance in some obvious cases

[Robert L. Read]

On Thu, 2007-11-29 at 21:25 +0200, Alex Mizrahi wrote:
> 
>  RLR> Postmodern does exactly the same thing that CL-SQL does in this
>  RLR> respect; the code was copied directly from the CL-SQL code.
> 
> from original Henrik's announcement:
> 
> ----
> The implementation is actually quite different from
> the clsql backend.
> ...
> The db-postmodern cursor is based on a sql cursor. Each btree has its
> own database table.
> ----
> 
>  IE> SQL backend cannot support the ordering constraints of an index
>  IE> without reading all the objects into memory
> 
> and postmodern cannot support them too.
> however we do not really need to support ordering to do by-value
> queries.
> as for by-range queries, they should work in db-postmodern when keys
> are 
> strings-only or integers-only, which is probably most useful case. we
> are 
> going to improve it to support NILs among values.
> 

I think this makes a lot of sense.