On Monday 13 May 2002 1:49 pm, Taylor Lewick wrote: > Hi All, I am fairly new to mysql.. > I am using perl, mysql, and apache to do a little development, and to learn > quickly I am trying to do some real dbase transactions... > > I have a program whcih gets a bunch of stock quotes from the internet (say > about 5000) it returns symbol, price, time, etc (about 10 columns) What > would eb the best way to organize a table or tables if I wanted to store > about a month or twos worth of data.. Just store 1 big table with name as > primary key and data as a unique value, or is there a better way to store > large amounts of similar records...
Read up on database normalisation. I'd recommend splitting it up into at least two tables, one containing stock information regardless of time and the other containing a specific quote. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
