tg-php@xxxxxxxxxxxxxxxxxxxxxx wrote:
So you have two "single table" votes.. make this a third. I'm guessing that each time you collect data, it's going to be one of each piece of data every time. As for efficiency, it's probably more efficient to keep everything in one table and do your statistics by using SQL to filter down by date and use aggregate functions like SUM() and whatever your database's version of AVERAGE and other math functions are. This way, it's handled very quickly and efficiently inside the database engine
another suggestion. create several another tables also. that maintains only the daily averages etc... or any other data that u may need to run on to get your stats.
running Mysql average, sum command on that single database everytime will be rather cumbersome. it will be faster to run commands once and store in a database. ie. cache
-- Thanking You Sumeet Shroff http://www.prateeksha.com Web Designers and PHP / Mysql Ecommerce Development, Mumbai India -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
