egi roka

egi roka

  • NA
  • 87
  • 0

one ore many sql tables

Mar 18 2009 11:46 AM
Hi,
I build an application for a factory. Each workers has his/her transactions. A few hundred workers, a few hundred transact/per worker/year.
Which is better:
1.  to create programtically a 'personal transaction' table (in sql of course), for each wokers when he/her joins the factory and drop the table when he/she quits.
or
2. build and feed a single huge table with all transactions of all the wokers?



 
 

Answers (3)