Impact on System tables by creating & purging tables frequently [1k-5k tabs/Hr]
Greetings Everyone :)
We are developing a reporting tool, where we can select the fields of report & customize as we want from very large options. since we are gathering data from multiple sources we have design the code as such it would create table, dump data, process it, generate report & purge table..
out of normal table option & PTT[Private Temp Tables] option, normal table option is much better since it gives best performance & we can create require indexes as well.. However I think this could lead to we bloat system tables with very frequent inserts & deletes of new tables data definitions at long term.