Re: Guaranteed unique?

Julian Bond <julian_bond-/Fkc1E/MbsFWk0Htik3J/[email protected]> Sat, 10 Jan 2004 09:26:24 +0000
Newsgroups gmane.network.syndication.discuss
Message-ID <[email protected]>
pavka14 <pavka14-/[email protected]> wrote:
>The database is too heavy on our site and we don't want to make a
>query to find out if we already have a tex somewhere with the same
>guid, so we don't want to use guid.

This is a database problem. Put appropriate indexes in place and the 
queries won't be heavy. What I do is for each item, check for uniqueness 
against
- <guid>
- <link>+Channel
- <title>+Channel
I only get caught by the few remaining blogs who insist on having one 
item per day and update it though the day. (Doc Searls, dammit!)

-- 
Julian Bond Email&MSM: julian.bond at voidstar.com
Webmaster:                 http://www.ecademy.com/
Personal WebLog:          http://www.voidstar.com/
M: +44 (0)77 5907 2173      T: +44 (0)192 0412 433

 

Yahoo! Groups Links

To visit your group on the web, go to:
 http://groups.yahoo.com/group/syndication/

To unsubscribe from this group, send an email to:
 [email protected]

Your use of Yahoo! Groups is subject to:
 http://docs.yahoo.com/info/terms/