Stress tests

[Ruslan Zasukhin]

On 4/24/06 7:37 AM, "Kem Tekinay" <ktekinay at mactechnologies.com> wrote:

Hi Kem,

> While preparing to release Data-On-Demand ListBox v.1.5, I decided to run a
> stress test using Valentina on the backend. I created a 5 million row test
> file of 7 fields and imported that. I'm happy to say that Data-On-Demand
> ListBox performs well, but I discovered some interesting things about
> Valentina. Keeping in mind that none of this was done in a scientific way:
> 
> - Valentina was inited with a 40 MB cache. The data was imported using
> Valentina's ImportText command.
> 
> - Sorting data on an indexed field took about 10 seconds on my dual-2.5 GHz
> PowerMac G5, but the sort was incorrect. That is, in what should have been a
> simple alphabetical sort, the first row started with a "D" when there were
> "A"'s available. Reindexing with Valentina Studio solved that problem.

Yes, we also have see some bug for table with 5 millions records.
In our V4rB Test Project. Soon I will check it
 
> - Searches were performed using the class-way on the three indexed fields,
> Zip, City and State. A "starts with" search was almost instant no matter how
> many results were returned. For example, "zip, city, or state starts with 1"
> yielded 542,283 records and took 0.015 seconds. (BTW, Data-On-Demand ListBox
> displayed those results in 0.147 seconds, and the whole 5 million rows in
> under 1.5 seconds!)

Actually I wonder why number of results differ result.

Data-On-Demand ListBox should display 1000 and 1000000 records in the same
time.


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]