advice on loading my mysql
Posted: Sun May 30, 2010 3:54 pm
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.
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.