• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: Core Data Fetch request very poor performance ??!
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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

  • Prev by Date: Re: Message.framework
  • Next by Date: Re: Message.framework
  • Previous by thread: Re: Core Data Fetch request very poor performance ??!
  • Next by thread: RE: Core Data Fetch request very poor performance ??!
  • Index(es):
    • Date
    • Thread