Click here to Skip to main content

Welcome to the Lounge

   

For lazing about and discussing anything in a software developer's life that takes your fancy.
The Lounge is rated PG. If you're about to post something you wouldn't want your kid sister to read then don't post it. No flame wars, no abusive conduct and please don't post ads.

Technical discussions are welcome, but if you need specific help please use the programming forums.


 
GeneralRe: Swatting a fly with a nuke PinmemberKyudos15-Jan-13 16:13 
GeneralRe: Swatting a fly with a nuke PinmemberBassam Abdul-Baki16-Jan-13 0:37 
GeneralWell, I Give Up (on SQL) PinprotectorAspDotNetDev14-Jan-13 15:09 
GeneralRe: Well, I Give Up (on SQL) PinprotectorMarc Clifton14-Jan-13 15:33 
GeneralRe: Well, I Give Up (on SQL) PinadminChris Maunder14-Jan-13 15:35 
GeneralRe: Well, I Give Up (on SQL) PinprotectorAspDotNetDev14-Jan-13 16:14 
GeneralRe: Well, I Give Up (on SQL) PinmemberPIEBALDconsult14-Jan-13 16:54 
GeneralRe: Well, I Give Up (on SQL) PinprotectorAspDotNetDev14-Jan-13 17:23 
I did similar, though a LIKE '%Whatevs%' was too slow, so we split the strings and tossed them into a table like this (this is a simplified version):

SectionCompleteType
yUglyName
lyUglyName
glyUglyName
UglyUglyName
3123ID
23123ID
123123ID
CABCSKU
BCABCSKU
ABCABCSKU
cUgDocDocument
ocUgDocDocument
DocUgDocDocument
gDocUgDocDocument
UgDocUgDocDocument
Then we could do SELECT DISTINCT Complete, Type FROM Sections WHERE Section LIKE @Input + '%'. That can use the index rather than a full table scan (and still allows for the middle of a string to be searched). Then we use the compete string to do an index seek in the other tables. But that was before the addition of "Color" as a filter. That's where things get complicated.

GeneralRe: Well, I Give Up (on SQL) PinadminChris Maunder14-Jan-13 18:14 
GeneralRe: Well, I Give Up (on SQL) PinprotectorAspDotNetDev14-Jan-13 18:55 
GeneralRe: Well, I Give Up (on SQL) PinmemberNagy Vilmos15-Jan-13 0:10 
GeneralRe: Well, I Give Up (on SQL) PinmemberPIEBALDconsult14-Jan-13 15:52 
GeneralRe: Well, I Give Up (on SQL) PinmemberRutvik Dave14-Jan-13 18:32 
GeneralRe: Well, I Give Up (on SQL) PinmemberJim Meadors14-Jan-13 20:05 
GeneralRe: Well, I Give Up (on SQL) Pinmemberdigimanus14-Jan-13 21:58 
GeneralRe: Well, I Give Up (on SQL) PinprotectorAspDotNetDev15-Jan-13 3:40 
GeneralRe: Well, I Give Up (on SQL) Pinmemberdigimanus15-Jan-13 3:43 
GeneralDell Buyout PinmemberKevin Marois14-Jan-13 11:16 
GeneralRe: Dell Buyout PinmentorDaveAuld14-Jan-13 11:29 
GeneralRe: Dell Buyout Pinmember_Maxxx_14-Jan-13 12:26 
GeneralRe: Dell Buyout PinmentorDaveAuld14-Jan-13 12:31 
GeneralRe: Dell Buyout Pinmember_Maxxx_14-Jan-13 12:47 
NewsHMV Next? [modified] PinmentorDaveAuld14-Jan-13 9:59 
GeneralRe: HMV Next? PinmemberClifford Nelson14-Jan-13 10:04 
GeneralRe: HMV Next? PinmentorDaveAuld14-Jan-13 10:08 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Advertise | Privacy | Mobile
Web04 | 2.8.140721.1 | Last Updated 30 Jul 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid