I have a stock table in my database with 20k records.
I'm not experiencing any performance issues.
At this stage, I could split this large table into 3 smaller tables. One for stock, price, and category and simply join them in a query.
Is there a real performance issue leaving one large table or is this really not necessary?
I'm not experiencing any performance issues.
At this stage, I could split this large table into 3 smaller tables. One for stock, price, and category and simply join them in a query.
Is there a real performance issue leaving one large table or is this really not necessary?