Hi John,
I don't think you'd notice any performance penalties at all. In each of
your four templates that list out the links simply edit your CFQUERY tag
that get's the links from the database, and add WHERE StatusFlag = 1. On
the search page, add the same WHERE StatusFlag = 1 to the search
query. They're the only changes that you'll need to make on the 'live' side.
Nick
At 09:02 15/05/00 -0500, you wrote:
>Thanks, Nick.
>
>This makes sense, as it's probably simpler than trying to maintain two
>sets of tables. However, there may be a downside: I have five templates,
>plus a search form that look at these links. Four of them list all of
>the links in various ways. For each, I would have to add the display
>flag. Given that the number of links is likely to climb to nearly 10,000
>at some point, do you think there would be a performance penalty?
>
>Thanks so much for the opinion.
>
>--John
>
>Nick Slay wrote:
> >
> > Hi John,
> >
> > Personally, I'd have a StatusFlag on my Link Table. Let people submit
> > links directly to the Links table and set the StatusFlag to 0,
> > (Pending). Create yourself a password protected admin script that let's
> > you update the StatusFlag, then once the Links have been approved, set the
> > StatusFlag to 1 (Ok). The page on your site that lists the links then
> > only needs to query the records that have a StatusFlag = 1.
> >
> > HTHAL
> >
> > Nick
> >
> > At 06:42 15/05/00 -0500, you wrote:
> > >I accept submissions for links to be listed on one of my sites.
> > >Originally, this was merely by E-mail. Then I set up a form, so I could
> > >get as many fields filled in as possible and save some research time.
> > >The form generated an E-mail to me and the sender.
> > >
> > >Now, I'd like to have submitters enter the info directly in my database.
> > >Should I let them enter it in my main tables, or should I create
> > >separate tables and, once I approve the submissions, copy them to the
> > >main tables?
> > >
> > >If I do it the first way, I'd need to set up a flag to allow display,
> > >once I've approved the submission. Any thoughts on the best way to do
> > >this?
> > >
> > >TIA,
> > >--John Allred
> > >
> > >
> > >--
> > >John Allred / Jackson, Mississippi
> > >Webmaster, Mississippi Counties
> > >http://www.mscounties.com/
> > >-----------------------------------------------------------------------
> -------
> > >Archives: http://www.eGroups.com/list/cf-talk
> > >To Unsubscribe visit
> > >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> > >send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> > >the body.
> >
> >
> ------------------------------------------------------------------------------
> > Archives: http://www.eGroups.com/list/cf-talk
> > To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
> or send a message to [EMAIL PROTECTED] with 'unsubscribe'
> in the body.
>
>--
>John Allred / Jackson, Mississippi
>Webmaster, Mississippi Counties
>http://www.mscounties.com/
>------------------------------------------------------------------------------
>Archives: http://www.eGroups.com/list/cf-talk
>To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in
>the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
