To Joakim about speed of first query.

[Joakim Schramm]

> -----Original Message-----
> From: valentina-bounces at lists.macserve.net 
> [mailto:valentina-bounces at lists.macserve.net] On Behalf Of 
> Ruslan Zasukhin
> Sent: 26 April 2007 14:09
> To: valentina at lists.macserve.net
> Subject: Re: To Joakim about speed of first query.
> 
> On 26/4/07 2:56 PM, "Joakim Schramm" <joakim at astrocalc.com> wrote:
> 
> Hi Joakim,
> 
> > I just note that I have done partial searches on this data in other 
> > databases and even MSACCESS do it better then Valentina here, if we 
> > stick to this first search scenarion. In next phases, 
> Valentina leave 
> > them all behind by miles...
> > 
> > Can I suggest you continue to look at this, maybe some 
> little detail 
> > have been overlooked some were ;-)
> 
> Of course we will. Do not worry.
> Than more that you say Access do not show this behavior.
>  
Well some year ago I had this data loaded into an Access database for
testing, which of course couldn't deliver the speed I wanted but at the time
I was not able to find any other usable db for local application (not
server). I will recall a partial search like "StartWith" didn't take this
long although it was slow. But I am sure there were no such behave on very
first query, for sure.

So at that time I kept things in text files as it was faster. Later I found
a db called Tsunami, which is Btree based I think, not relational and no
SQL. It was pretty fast though, but a bit complicated to work with and not
as fast as Valentina. There was no such first query behave though on a
partial search. I can't recall exactly now and I have no longer access to
their support forums, but it sure was many times faster then Valentina on
this first query.

> > Interesting you say this have been there all the time, since v1, I 
> > simply must haven't thought of it, until I got reports 
> about crashes.
> 
> Sorry, I have not catch, about what crashes you say now?
> 
Well some of my Beta testers have reported crash or rather "infinitive" hang
on first query, forcing them to kill process with Windows Task Manager or
simply reboot PC. I don't know spec for all computers but in one case I know
it's an Athlon 700 and my guess is the other also have low spec of computer.

I have never had crash on this, only delay upto 20 sec. but my PC have quite
good spec P4 3.0 HT and 2GB RAM and 340GB HDD with 8MB cache, ASUS mobo.

Regards,
Joakim