[RBG7-L] - Re: View Speed

[Paula Stuart]

Title: Message

This may be way too obvious, but are you regularly reloading the database?  The only time I've experienced any serious degradation in processing time like this was when the database had gotten big and sloppy over time.  The first thing I do is reload and that usually gets things back to normal.    I'm running a database of 350,000 records with a response time on the type of selection you're trying to do that's very fast.     Paula Stuart 617-776-3367 617-776-4554 (Fax) 617-388-1331 (Cell) [EMAIL PROTECTED]   -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Steve Breen Sent: Wednesday, December 08, 2004 8:44 AM To: RBG7-L Mailing List 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!