steph.hope Posted March 25, 2020 Share Posted March 25, 2020 As it says in the title, if I have additional data to save to the database, is it better / safer / more efficient to add a column to an existing table (tblorders in this case) or to create a new table with the order id and my new column, which would then have to be queried in addition to the tblorders when I want to view order data? 0 Quote Link to comment Share on other sites More sharing options...
WHMCS Technical Analyst WHMCS Sachin Posted March 25, 2020 WHMCS Technical Analyst Share Posted March 25, 2020 Hello, It is recommended to create a new table in such scenarios so that the integrity of the stock tables (like tblorders) is not compromised by adding new columns. You can create as many new tables as per your requirements, to store additional data. 0 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.