How to Format Payroll Database?

[cmdr_bond]

Hi,
I am making a database to store payroll date for employees at my company, and I was wondering what the most efficient format would be to store the information.

Is it best to have a table and create a new row for each employee every week that states the hours s/he worked and the taxes paid and net check amount? Or would that make too many rows and is it better to create a new column for every week and just have one row for every employee?

Thanks

[bradgrafelman]

Personally, I would go with the 'new row/week' method just because I think it would be easier to work with, plus you're not going to be stressing the database that much anyway.

If it's load on the DB you're worried about, setup two different tables and fill them with a bunch of data. Start doing some benchmark timings and see which one takes longer.