I want to clean up the table really bad but I don't have the time. It is updated everyday by a text file that comes from an AS400 database. You should see it!. Ewwwwwww This one table has been the source of many nightmares.
Phillip B. www.LoungeRoyale.com www.FillWorks.com ----- Original Message ----- From: "Raster, Tim" <[EMAIL PROTECTED]> To: "SQL" <[EMAIL PROTECTED]> Sent: Monday, September 08, 2003 2:52 PM Subject: RE: I need some indexing advice > As painful as it sounds, I would investigate changing DB structure. In > the long run, you'll be happier. > > Just MHO. > > But, in the meantime, 1.5 secs sounds like a vast improvement! :) > > > -----Original Message----- > From: Phillip B [mailto:[EMAIL PROTECTED] > Sent: Monday, September 08, 2003 14:42 > To: SQL > Subject: Re: I need some indexing advice > > The table is horrible. I have all brand in the one table. Instead of > being > bit the are int and there is nothing preventing any number from going > in. > Long story. :( So should I skip trying to index these? > > Just indexing the zip field my page load went from 11 seconds to about > 1.5. > > Phillip B. > > www.LoungeRoyale.com > www.FillWorks.com > ----- Original Message ----- > From: "Raster, Tim" <[EMAIL PROTECTED]> > To: "SQL" <[EMAIL PROTECTED]> > Sent: Monday, September 08, 2003 1:56 PM > Subject: RE: I need some indexing advice > > > > Uh, oh. That smells like trouble. Are these 8 brands in separate > > fields in the table? If so, that's probably bad. You probably should > > pull that off into a 1-many linked table instead. > > > > Or do you mean something else? > > > > > > -----Original Message----- > > From: Phillip B [mailto:[EMAIL PROTECTED] > > Sent: Monday, September 08, 2003 13:30 > > To: SQL > > Subject: Re: I need some indexing advice > > > > I have about 8 brands that can be searched on. So, should I make one > > index > > that includes all 8 brands? I think I should but I want to check > first. > > > > Phillip B. > > > > www.LoungeRoyale.com > > www.FillWorks.com > > ----- Original Message ----- > > From: "Raster, Tim" <[EMAIL PROTECTED]> > > To: "SQL" <[EMAIL PROTECTED]> > > Sent: Monday, September 08, 2003 11:32 AM > > Subject: RE: I need some indexing advice > > > > > > > Yup. And look for opportunities to index multiple fields within an > > > index, if both are commonly searched. > > > > > > Others may disagree with me here, but I usually follow the > philosophy > > > of, "When in doubt, index it." It's usually only in very extreme > > > (highly transactional) cases that the index will hurt. If your > > database > > > is fairly static, then index the crap out of it. > > > > > > > > > > > > -----Original Message----- > > > From: Phillip B [mailto:[EMAIL PROTECTED] > > > Sent: Monday, September 08, 2003 11:25 > > > To: SQL > > > Subject: Re: I need some indexing advice > > > > > > I should have also mentioned that part of the where clause is what > > brand > > > they sell. Should I consider indexing the brand fields as well since > > > that is > > > a common search criteria? > > > > > > Phillip B. > > > > > > www.LoungeRoyale.com > > > www.FillWorks.com > > > > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:6 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:6 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=<:emailid:>.<:userid:>.<:listid:> This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
