Re: Database Application with Obj-C
Re: Database Application with Obj-C
- Subject: Re: Database Application with Obj-C
- From: Ruslan Zasukhin <email@hidden>
- Date: Wed, 24 Dec 2003 00:34:00 +0200
on 12/23/03 6:42 PM, Kim Friesen at email@hidden wrote:
>
Caveat : I am new to MVC and Cocoa, my thoughts come from
>
PeopleSoft/Oracle consulting
>
>
>
True, I agree with your thoughts regarding performance of current
>
database technology, I use Oracle everyday. But we haven't spoke of
>
scale at all. If we are talking about a 10-500 GB database, I wouldn't
>
choose anything but Oracle.
You are lucky.
I think not many developers and small business can afford Oracle :-)
>
If we are talking a 10 MB - 1 GB database, do I need something of that
>
magnitude ?
>
>
What about a 200-300 MB inventory database for a small warehouse with
>
10 clients ? Would a Cocoa version of Prevayler work ?
>
http://www.prevayler.org/wiki.jsp On a G5 server with 8GB of RAM would
>
I need to worry about disk access on a database that is under 1 or 2GB
>
? The current PeopleSoft HR system that I am working on has a
>
read/write ratio of over 93% reads versus 5-7% writes.
I have look on this Prevayler.
Just ant to say, that benchmarks are quite not accurate and non fair.
They do simple search WHERE fld = 'aaa'.
Since Prevayler use most probably simply a Tree for indexing,
They need walk small number of nodes of tree.
On repeated queries this nodes can be cached by CPU.
To make tests more fair, they must AT LEAST do search of RANDOM value.
And to make them not so super-fast, it needs simply make a RANGE query
WHERE fld > v and fld < v2
When result of query will be 100,000 records from million,
Or million from 10M records.
Then I think their speed will go down down significantly.
Also I have not found what language for query they use?
It seem not SQL but simply Java.
Excuse me then, but SQL parser gives big overhead.
But it is vital for REMOTE queries.
--
Best regards,
Ruslan Zasukhin [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: email@hidden
web:
http://www.paradigmasoft.com
To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------
_______________________________________________
cocoa-dev mailing list | email@hidden
Help/Unsubscribe/Archives:
http://www.lists.apple.com/mailman/listinfo/cocoa-dev
Do not post admin requests to the list. They will be ignored.