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:> Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
