1. Re: Database question -> M Lewis; P Lomax
Chris Burch wrote:
>
> You should also look at eusqlite (in the archives, originally Ray Smith's),
> but its v v simple sql, and incredibaly fast (40 mb, not indexed, in 3 seconds
> on a 733MHz Linux machine).
>
> Unfortunately, I haven't done any speed comparisons (yet) with eusql (and
> I'm not starting a 'mine is better than yours' debate 
)
It will almost undoubtedly be faster than EuSQL. Although I think I've made
some pretty good optimizations with EuSQL (at least with regards to looking
up data through select queries), it's not going to be faster than most
other DBs that are coded in C or similar, especially for large databases.
That said, however, I believe that it's an appropriate tool for smaller
databases, and can of course be sped up through translation and compilation.
The benefit is that you've got a database that can be easily read with
Euphoria, since it's built on top of EDS, and it's 100% Euphoria, so in
theory you could make your own modifications to it. Though I doubt anyone
else has the patience to wade through the code and figure out how it
works--some major portions of the code are fairly complex at this point.
It takes me a bit of time to remember why pseudo_to_records() is the way
that it is.
Matt Lewis
