Mailing Lists: Apple Mailing Lists

Image of Mac OS face in stamp
 
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Application Optimization



> I've tried keeping a comma delimited list in my database of the
> indexes of all read entries and when a user pulls up a page I check
> to see if the entry's id is in the list, but this slows down when
> there are more than 1,000 entries that have been read and are
> therefore in the databases list.

Use a relational database like MySQL and implement the setting of the Read
Status using Ajax (XML/HTTP Request - google for it).

Store the feeds in the database and have one BOOLean column for the read
status. That way you can pull in the read status in one query with the feeds
all from nicely indexed database. Should be fast enough.

--
Stefan Seiz <http://www.stefanseiz.com>
Spamto: <email@hidden>



 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Web-dev mailing list      (email@hidden)
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/web-dev/email@hidden

This email sent to email@hidden



Visit the Apple Store online or at retail locations.
1-800-MY-APPLE

Contact Apple | Terms of Use | Privacy Policy

Copyright © 2007 Apple Inc. All rights reserved.