Re: [PHP] Accumulated Information in DB??
As the previous comment states: MySQL is a DB, it's built to store data, so it's pretty good at it, and the limiting factors re usually your hardware/OS. However, just one thought. I am always very protective of my databases. If data is never going to change and no other process will be accessing the data , then I usually think twice before i store it in a db. It sounds to me like these reports are pretty "static" once they are run, ie, they are date dependant ( report xyz for the period 2000-01-01 to 2001-01-01), and arguably, the data that was used to generate that specific report is also "fixed" in history. So my assumption would be that the report would also never change again. So, if that is the case, why not generate the report, and simply save the "static" html version of the report on the file system as a normal html file? If your reports are not as my assumption states, then simply store them in mysql, i assure you it can handle it. As I stated, you must just be aware of hardware and your OS/filesystem limitation wrt table sizes. On Wed, 2003-10-01 at 08:39, [EMAIL PROTECTED] wrote: > Hi all, >I am having some doubts here and hope to hear some advices/solutions from > all of you out there. Right now, I have a daily, weekly, monthly and yearly > reports which stores information on all my customers. These info will of course, > be stored in the DB.(MySQL). As all these reports are not to be deleted, it will > accumulate as years go by. And so, my question is: is it possible to have such a > system in my project and how should I go about doing it??Can the MySQL DB hold > all this big chunk of info? > > These report info are to be viewed in a graphical format(PHP Graph)later on > > Regards, > Irin. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Accumulated Information in DB??
> -Original Message- > From: [EMAIL PROTECTED] > Can the MySQL DB hold > all this big chunk of info? > I'm no authority on MySQL but i dont see any problems with holding 'big chucks' of info, The only limiting factor would be the size of your hard drive. You might get a more accurate answer from the MySQL mailing list: http://lists.mysql.com/ * This e-mail, including any attachments to it, may contain confidential and/or personal information. If you have received this e-mail in error, you must not copy, distribute, or disclose it, use or take any action based on the information contained within it. Please notify the sender immediately by return e-mail of the error and then delete the original e-mail. The information contained within this e-mail may be solely the opinion of the sender and may not necessarily reflect the position, beliefs or opinions of Salmat on any issue. This email has been swept for the presence of computer viruses known to Salmat's anti-virus systems. For more information, visit our website at www.salmat.com.au. * -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Accumulated Information in DB??
Hi all, I am having some doubts here and hope to hear some advices/solutions from all of you out there. Right now, I have a daily, weekly, monthly and yearly reports which stores information on all my customers. These info will of course, be stored in the DB.(MySQL). As all these reports are not to be deleted, it will accumulate as years go by. And so, my question is: is it possible to have such a system in my project and how should I go about doing it??Can the MySQL DB hold all this big chunk of info? These report info are to be viewed in a graphical format(PHP Graph)later on Regards, Irin. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
