Issue Bug Closed

#55891Insert a CheckIfRecordExists in Listmodule

Stefan Froemken 02/11/14, 19:06 updated 10/23/17, 21:42

Description

Hello Coreteam,

for now you check if records exists in table with COUNT. But on large tables this needs a lot of time. On one of our systems with 1,3 million records 0.3 seconds. I found out a larger SQL-Query which only takes the first col (uid) of a table and breaks further processing with LIMIT 1.

Stefan

Reviews 1