0002268: First search after reboot takes very very long time, then instant.

[Joakim Schramm]

> -----Original Message-----
> From: valentina-bounces at lists.macserve.net 
> [mailto:valentina-bounces at lists.macserve.net] On Behalf Of 
> Thorsten Hohage
> Sent: 24 April 2007 07:38
> To: Valentina Developers
> Subject: Re: 0002268: First search after reboot takes very 
> very long time,then instant.
> 
> 
> On 2007-04-24, at 01:46, Ruslan Zasukhin wrote:
> 
> > On 24/4/07 2:24 AM, "Joakim Schramm" <joakim at astrocalc.com> wrote:
> >
> >>> And we do not see ANY MORE serious bug reports.
> >>
> >> #2268
> >
> > Sergey is scheduled to profile your project Tomorrow.
> > Lets see what he will report to us.
> 
> 
> Perhaps I'm totally wrong here, but the description remembers 
> me at my issues with my "cashier-app". It was not the 
> execution of the query, but the starting of valentina, 
> loading of the db and putting the data in cache and all this 
> during "first query".
> 
> My solution (of course for server only!) is a simple app, 
> executed during startup of the server, which connects to the 
> server and database and simple do a "select c1, c2, ... from 
> t1 " for every table in the database.
> 
> So perhaps  my report
> 
> 	0002274: need option to load a database at start of the server
> 
> will contribute to this issue, too and additional option for 
> a table, like FrontBase, "load in cache during start up" 
> would really solve it.
> 
> Joakim if you're using VServer too then you should check if 
> starting and connecting with VStudio and execution of your 
> query before starting your app will resolve your speed issues.
> 

I don't think this is the same issue, I have profiled my own code and it's
clearly the query. I would belive it was as yours if it happened every time
app is started, but it's only first query after reboot. Otherwise it would
mean Valentina not release cache and memory when app closes and that is not
the case here I think.

> If you're using embedded / local databases then you need 
> something different I'm afraid.
> 

Yes I am using local only, so far. Thanks anyway.

/Joakim
> regards
> 
> Thorsten Hohage
> --
> objectmanufactur.com - Hamburg,Germany
> 
> 
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>