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' site: http://www.codeferous.com blog: http://david.codeferous.com -- Toronto Area Cocoa / WebObjects developers group: http://www.tacow.org
smime.p7s
Description: S/MIME cryptographic signature
_______________________________________________ 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]
