Using Into @variable statement with PDO?

@benanamen I have a series of forms that are each saved as their own individual table. On one page I am displaying the number of items in each form (each row in a table represents an item). I thought it would be much more cost efficient/faster to do one database call and get the row counts from all of the tables and then parsing it in the Javascript instead of making seperate database calls for each individual table. Is that not the case? (It totally could be, I’m new DB administration :slight_smile: )

image
(These are some examples from my testing database, but in production the sizes will all be much larger. You can see how inaccurate the sizes [i.e. row counts] are because I am currently using table_rows.)