ONE PROCEDURE VS 1000 PROCEDURES
ONE PROCEDURE VS 1000 PROCEDURES.
I have 10000 of users in a analytics application . Each using 1000 of different select sql.
My question is what's the best way to write this . Keeping in mind everyone is using bind values:-
1) Write 1000 distinct bunch of sql in a application .
2) Write 1000 different procedures in 1000 distinct sql.
3) Write 1000 different procedures in a sql.