I have 3 tables that are accessed using PHP. Company database is 800 rows, contracts are 2000+ rows and items are 10000+ rows. A user uses a function that loads all 3 database and works out service times of each individual item and whether it needs to be serviced that week, what contract it's with and what company and prints them on the page. Clearly the amount of loops executed is going to be huge. The user will then be able to click forward and see the following week. There are also other pages that are needed like company page where the user can click the company and show all contracts and items. This code was fairly straight forward but the client has expressed all data on the DB be encrypted as well. Is this going to be too much for the system? Would anyone know whether this many loops loaded then being decrypted would cause major slow down?
I was thinking that when a user first logs in the 3 tables could be loaded into an array and that passed between pages or are there security implications with this? Thanks for any advice.
advice on loading my mysql
Moderator: General Moderators
Re: advice on loading my mysql
For the first report all you need is one SQL query and one loop. Nothing more. For the second report it's the same, except some of this stuff will have to be "decrypted" before printing it to the screen.
And no, do not load the tables into memory. Database systems are around so you don't have to do that.
And no, do not load the tables into memory. Database systems are around so you don't have to do that.