pd2-2/Ricky — Issue #2: INSERT query...
Author: RobertShippey
Created: 2012-02-01 19:56:03+00:00
State: open

From the p.o.v of the RFID simulator:
"All I really want to do is insert data into the database. I'm supposed to run fast so any extra processing I'm doing will be detrimental to my purpose."

What he means is, all the INSERT should contain is; the student's card UID, the time, and the room.
I noticed the database defaults to the current time in the attendance table so really all it should be is:
```sql
INSERT INTO attendance(ntuID, room) VALUES (someID, someRoomNumber);
```
Currently I'm being told I need to put a session ID in. I'll only be happy doing that if I can get the DBMS to work it out for me in the INSERT statement because then it can optimise the hell out of it to keep everything fast.

Thoughts?