Re: time out (used to work fine and was indexed)

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: mike (anonymous_at_discussions.microsoft.com)
Date: 05/26/04 

Date: Wed, 26 May 2004 11:48:55 -0700

Aaron, thanks for offering. I just ran the view again
after removing all but the one product our company sells
that I'm interested in. That reduced the size of the main
table I'm working with (which is not indexed) to about
300,000 records and it worked, albeit a little slower than
usual. I don't even think I can adequately explain this at
the moment, so I'll dig a little deeper, see if I can get
it work with all records included, 2M which I'm sure we'll
need to look at sometime soon, and come back with a more
focused question. Thanks!

Relevant Pages

  • Moses and Aaron
    ... Moses. ... "Oh, not too bad Aaron, how are you?" ... "Yeah, I suppose we are all a bit 'ornery. ... she will have to make a sin offering. ...
    (uk.religion.christian)
  • Re: Why do IT guys hate MS Access?
    ... put two pence in the offering. ... > TTBOMK Aaron Kempf has been an enthusiastic and capable ADP proponent ...
    (comp.databases.ms-access)
  • Re: Quote()
    ... he may be offering suggestions for improvement ... and then removing it again). ... DHTML Death Colors: ... 'Faith without judgement merely degrades the spirit divine.' ...
    (microsoft.public.scripting.jscript)
  • Re: Big News at AP!
    ... Hmm, interesting. ... I'd think they'd be more concerned about removing ... 10 year wait on their other scopes before offering new ones. ...
    (sci.astro.amateur)