Re: Saving WOCheckboxes in a Repetition into a database

Thu, 05 Oct 2006 18:40:21 -0700

Hi David,

No, I'm saying that people need to select favourites from a paged list of 20,000, but they need to be able to see which records have already been marked previously.

I was just walking home and thinking that what might work is another mutable array keeping track of only the recent additions, just as I have done for the removals. I'll try it in the morning.

Thanks,
David


On 5-Oct-06, at 6:30 PM, David LeBer wrote:

On 5-Oct-06, at 9:13 PM, David Holt wrote:

The following code derived from mmalc's article on Stepwise is what I have been using to store "favourites" to the database. I show the items that have been marked as favourites when the page loads. When I submit, the code loops through every artifact in the database (some 20,000) and is dog slow. The inefficiency didn't show up until I connected to the production database. Does anyone have any suggestions for how I might make this code more efficient?

Sorry, are you saying that you end up with a page with 20,000 favorites on it?

If so, that's never going to work (code optimization  or not) and your going to want to look at reducing that number drastically (paging, searching, or filtering, or something).

If I've misinterpreted, let me know.

--
;david

--
David LeBer
Codeferous Software
'co-def-er-ous' adj. Literally 'code-bearing'
--
Toronto Area Cocoa / WebObjects developers group:


 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      ([email protected])
Help/Unsubscribe/Update your Subscription:

This email sent to [EMAIL PROTECTED]

-- 

It's like driving a car at night. You never see further than your headlights, but you can make the whole trip that way. 


E. L. Doctorow


from Sunbeams: http://www.thesunmagazine.org 


 

 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

This email sent to [email protected]

Reply via email to