Re: raw sql, eo and cache

Ricardo Strausz <[email protected]>
Newsgroups gmane.comp.web.webobjects.devel
Message-ID <[email protected]>
Hola Trond!

I think that the best for this is to load your stored-procedures into  
your model and use them within...
EOModels can get quite sophisticated but they will save you several  
headaches... specially because you can keep the EOF's  paradigm  
instead of doing all your self.

Raw SQL most not be used but only as a last resource...

Suerte!
Dino

On Oct 20, 2006, at 2:00 PM, [email protected] wrote:

>
> Date: October 20, 2006 3:36:23 AM GMT-05:00
> Subject: raw sql, eo and cache
>
>
> hello
>
> this is question that i have thought about for a long time.
> i am using an oracle database as a datastore.  the database manager
> want me to call stored procedures to get data.
> the stored procedure returns a table of data.  the only solution
> i could find was to use raw sql and pick the data from
> a NSArray of NSDictionaries.
> i am a bit worried for the performance.  will eo cache
> the data and/or do some kind of "lazy fetches?
>
> thank you.
>
> trond.



--
Ricardo Strausz
Business Applied C Objects
dinos[@]mac.com
http://homepage.mac.com/strausz/baco
(+52-55) 5437-8205

_______________________________________________
WebObjects-dev mailing list
[email protected]
http://www.omnigroup.com/mailman/listinfo/webobjects-dev
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.