lcollong
FabriKant d'applications web
Hi,
I use this list plugin to check if a given row from a reference table could be deleted or not as it could be used in the data table to provide valuable linked informations.
Thus I use eval to check if the id is present or not in the foreign key columns of a pretty big table (select count(*) from huge_table where fk_ref=X). But the sql is triggered 4 times for each row.
Could you confirm ? Wouldn't produce heavy sql load ?
edit : the number of times the code is run increase with the number of rows in the reference tables (the one where the plugin is).
I use this list plugin to check if a given row from a reference table could be deleted or not as it could be used in the data table to provide valuable linked informations.
Thus I use eval to check if the id is present or not in the foreign key columns of a pretty big table (select count(*) from huge_table where fk_ref=X). But the sql is triggered 4 times for each row.
Could you confirm ? Wouldn't produce heavy sql load ?
edit : the number of times the code is run increase with the number of rows in the reference tables (the one where the plugin is).
Last edited: