[RBG7-L] - Re: View Speed

[David M. Blocker]

It's a puzzler and we'll all be interested in what you learn.  Good luck!   David Blocker [EMAIL PROTECTED] 781-784-1919 Fax: 781-784-1860 Cell: 339-206-0261 ----- Original Message ----- From: Steve Breen To: RBG7-L Mailing List Sent: Wednesday, December 08, 2004 8:44 AM Subject: [RBG7-L] - Re: View Speed David,   This is an interesting problem that I am going to get to the bottom of with some testing but for the next couple of days I am off on another project.   I am going to try projecting an new table with the same data but different column names and see if I get the same results.   If this works then will look for the problem in the structure of the database. If this was a consistent problem it would be nice but some aspects are working great.   Steve Breen -----Original Message----- From: David M. Blocker [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 08, 2004 8:29 AM To: [EMAIL PROTECTED] Subject: [RBG7-L] - Re: View Speed Steve   Perhaps an obvious question, but is CustNub2 indexed? Or does it have a foreign key constraint on it? This time sounds WAY slower than any simple indexed query I've ever run on any version of R:Base!