[GENERAL] Which design would be faster ...

2008-07-16 Thread Haim Ashkenazi
Hi I'm creating an application that have an fixed length alphanumeric key and each key has (currently) up to 5 fixed length alphanumeric variables. I was wondering which of the designs would be faster considering that I could have about million keys... The first design is the obvious one. create

[GENERAL] need help in designing a database.

2005-11-27 Thread Haim Ashkenazi
Hi I'm writing an application that calculates working hours for billing. there are three levels of billing. one for regular hours, one for evening/nights, and one for saturdays/holidays. My first decision is wether I make these calculations in a database view (If I understand correctly, it would

Re: [GENERAL] need help in designing a database.

2005-11-28 Thread Haim Ashkenazi
On Mon, 28 Nov 2005 10:32:53 +, Richard Huxton wrote: > Haim Ashkenazi wrote: >> Hi >> >> I'm writing an application that calculates working hours for billing. >> there are three levels of billing. one for regular hours, one for >> evening/nights, and