Select Layer by Attribute running extremely slow in modelbuilder

Discussion created by rzinck@sbcglobal.net on Aug 22, 2012
Latest reply on Sep 5, 2012 by rzinck@sbcglobal.net
Hi, hoping someone might have a solution/ answer to this.

I create a join in modelbuilder then want to select all those records (the ones that match).  I'm using the Select Layer by Attributes tool requesting NEW SELECTION.  This has worked before and taken only a couple minutes, but recently it has been taking 1 hr+.  I have 200,000+ that are being selected, but this still seems to take way longer than it needs to.  When doing this through ArcMap in the attribute table this goes very quickly.   But this is just a small part in large model, and really would like to get the model to work. This seems to be the only issue i'm having with it, but it is defeating the purpose of of creating the model in the first place.

Any help would be much appreciated, Thank You Very Much