Re: Core Data Fetch request very poor performance ??!
Re: Core Data Fetch request very poor performance ??!
- Subject: Re: Core Data Fetch request very poor performance ??!
- From: Ruslan Zasukhin <email@hidden>
- Date: Tue, 29 Nov 2005 18:46:58 +0200
- Thread-topic: Core Data Fetch request very poor performance ??!
On 11/29/05 6:38 PM, "Bill Bumgarner" <email@hidden> wrote:
Hi Bill,
> Were you using a "RAM-based Valentina 2" database?
No. Valentina is TRUE disk based database. It can work from CD and DVD also.
But yes, Valentina v2.0 also have option for developers to create
- RAM based database
- RAM based tmp tables in the scope of disk based database.
The benches below, was on disk based database.
Also make sure, I have made all the best to get the best speed of SqlLite.
We have test as indexed so non-indexed cases.
> On Nov 29, 2005, at 6:21 AM, Ruslan Zasukhin wrote:
>
>> On 11/29/05 3:44 PM, "I. Savant" <email@hidden> wrote:
>>
>>> However, it's also worth mentioning that Valentina (at least from
>>> what I see on the web site) is not free. SQLLite is.
>>
>> Yes right.
>> Valentina for Cocoa will have price $199 by the way.
>> But when developer get show stopper problems, Valentina can help.
>> I also have made fast benches of SQlLite 3.
>>
>> On db with 100MB (million records in one table), SqlLite did response on
>> different SIMPLE queries up to 30 seconds. More complex queries such as
>>
>> select distinct * from T
>>
>> take minutes. I did wait 7 minutes and interrupt.
>> Valentina all queries answer on this db in about 0.1 seconds.
>>
>> Again, I even did not test more complex things, as joins, group by, distinct
>> on join, and so on... If single table query is so slow all rest is out of my
>> interest.
--
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]
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Cocoa-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden