Stress tests

[Ruslan Zasukhin]

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

> - 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.

And time still 10 sec?

Note, FIRST sorting on a field can be much slower than next sorting.
So try do SECOND the same sorting.
 
> - 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!)
> 
> - "Ends with" searches were slower. For example, "zip, city, or state ends
> with 1" yielded 651,666 records and took from 2.5 to 4.0 seconds.
> 
> - "Contains" searches took longer. "Zip, city or state contains 55" yielded
> 167,816 records and took anywhere from 6.5 to 10 seconds.

Hmm, I'd expect the same result in both cases

> - "Like" searches were similar in speed to "contains" searches. For example,
> "zip, city, or state like 'n%w%k' yielded 254 records and took anywhere from
> 6.5 to 10 seconds.

> - While I was running these tests, Valentina did something that caused a lot
> of thrashing and that particular search took MUCH longer.

What search you mean here? LIKE ?
 
> - Even though there had been no crashes or other issues, I ran DIAGNOSE from
> Valentina Studio. VS reported "problems found" at the end, but the actual
> details showed no issues. After reindexing, there were no problems found.
 
> - The original import file was 397 MB, and the final Valentina database
> files combined to 736 MB.

This is size with indexes?
 
> - The 10 minute demo time limit is too annoying and limiting. There should
> be NO time limit in the IDE and a 10 minute time limit in compiled apps
> only.

Yes right. It seems even exists such request in Mantis.
Please remind us constantly this point. We need fix it asap I think.
Not hard in RB SDK
 
> My conclusion: Even at its slowest, Valentina truly is ridiculously fast.
> Even the slowest "like" search took only 10 seconds to search three fields
> in 5 million records. By comparison, the SQLite engine that comes with
> REAlbasic was too slow to use for this purpose.

-- 
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]