[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