[PERFORM] Performance Concern

2003-10-24 Thread John Pagakis
(could it be using a CHAR( 15 ) as a key?) but I'd *LOVE* any thoughts. Would I be better off making the key an identity field and not indexing on baz_number? Thanks in advance for any help. ______ John Pagakis Email: [EMAIL PROT

Re: [PERFORM] Performance Concern

2003-10-24 Thread John Pagakis
ve that time down even further. ______ John Pagakis Email: [EMAIL PROTECTED] "If you can't beat them, arrange to have them beaten." -- George Carlin This signature generated by ... and I Quote!!(tm) Copyright (c) 1999 SpaZmodic Frog Software, Inc.

Re: [PERFORM] Performance Concern

2003-10-24 Thread John Pagakis
saved me the effort of experimenting. Thanks for the benefit of your experience. __ John Pagakis Email: [EMAIL PROTECTED] "Oh, you hate your job? Why didn't you say so? There's a support group for that. It's ca

Re: [PERFORM] Performance Concern

2003-10-25 Thread John Pagakis
nded a group of updates; see my response to Rod Taylor's post here (and Rod, if you're reading this: you were *GREAT* in "The Time Machine" !! Answer 3: Oh, there was no question three !! Thanks again Christopher!! ______

Re: [PERFORM] Performance Concern

2003-10-25 Thread John Pagakis
nd, it looks to me like this table will be a bottleneck no matter what I do. Your thoughts, as always, are much appreciated. __ John Pagakis Email: [EMAIL PROTECTED] "If I had a formula for bypassing trouble, I would not p

Re: [PERFORM] Performance Concern

2003-10-25 Thread John Pagakis
saved me the effort of experimenting. Thanks for the benefit of your experience. __ John Pagakis Email: [EMAIL PROTECTED] "Oh, you hate your job? Why didn't you say so? There's a support group for that. It's ca