[Dbix-class] Fastest method to check for key existence?
Ekki Plicht (DF4OR)
ekki at plicht.de
Wed Feb 11 21:58:53 GMT 2015
Hi,
I need to check a list of values if they exist in a database. The
value is a unique key of that table. A stupid 'find' works of course,
but returns the whole row data, where I only need a simple binary
yes/no information if a row was found or not.
I am thinking of setting up a special resultset which contains only
the key as a returned value by SELECT, but I am wondering if there is
a faster method.
TIA,
Ekki
More information about the DBIx-Class
mailing list