Ok, so i have googled this q, but nothing comes up that is really informative.
I have just had a request to a a new function to the DB. This function will involve adding +- 15000 records DAILY to a table from a excel spread sheet. I am worried this will quickly overload the DB.
Suggestions ? maybe have two back ends, one for this specific table.....and one for all the rest ?
I don't wanna start coding until i am sure i am not gonna hit a brick wall very quickly.
Another thing i just thought of is maybe for the DB to on a daily basis export the current days records to a new table in a new DB to almost like an archiv e feature.
Again, any comment welcolm.