[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: Find records that has all items in the list

  • Thread starter Thread starter ChUIMonster
  • Start date Start date
Status
Not open for further replies.
C

ChUIMonster

Guest
Good luck. As Jonathon says above "this is slow". Using MATCHES in your WHERE clause is going to result in a table scan. If the target table is large performance is going to be somewhere between "poor", "abysmal" and "broken". Keep in mind that the table may not start life as a large table. But if it becomes large somewhere down the road you are going to have a problem on your hands.

Continue reading...
 
Status
Not open for further replies.
Back
Top