in reply to Re^2: OT - SQL choosing a schema for index tables
in thread OT - SQL choosing a schema for index tables
It's a bit unusual but if it works well and performs well, I wouldn't worry about it (because the data is so small).
But it would indeed (as already mentioned upthread) make more sense to have an SQL statement that JOINs the tables and that retrieves the rows that you want in one trip to the databaseserver. (But it's quite possible that you'd hardly notice a speed difference.)
|
|---|