first cursor

[Ruslan Zasukhin]

On 1/10/05 1:39 PM, "Olivier" <vidal_olivier at yahoo.fr> wrote:

> Hi list,
> 
> A strange thing with my app happens to me.
> I have a DB with 83 000 small records.
> 
> When I click a menu of my app, a window appears with an Einhugur'
> Datagrid (sort of fast listBox) fills 83 000 records.
> Thus, when the window opens, a cursor is created to obtain 83 000
> records of the DB.
> 
> With Valentina 1, the first time when I open this window, the datagrid
> puts approximately 1 second to fill.
> If I close the window and what I open it again, the datagrid fills
> almost immediately.
> 
> With Valentina 2, the first time when I open this window, the datagrid
> puts ......34 seconds to fill !
> If I close the window and what I open it again, the datagrid puts
> approximately 1 second to fill.

Long. This again can be result of not cached INDEXES.

> As the cursor is destroyed every time I close the window, I thought
> that the problem was linked to the cache.
> But if I puts the cache on 50 Mb, 1Mb or even 0.01 Mb, that changes
> nothing! (Same on Valentina 1)
> Nevertheless the DB makes 15 Mb with Valentina 1 and 37 Mb with
> Valentina 2 ( UTF16).


15MB difference this is just 0.5 second to read from HDD
 
> I also tried my DB with ViSQL for Valentina 1 and ViSQL for Valentina 2.
> If I launch a query to select all the records of my table (83 000) :
> 
> With ViSQL 1:
> 
> - The first time: 0.13 seconds
> - If I begin again: 0.06 seconds on average
> 
> With ViSQL 2:
> 
> - The first time: 0.28 seconds
> - If I begin again: 0.22 seconds on average

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------