On 10/17/11 12:44, Eurico Chagas Filho wrote: > Yeah, I guess that would work. But I don't like "manual". In the past i have > used the > windows schedule thing to start a program to clean up things. Didn't work very > well, sometimes would skip a day. I would need something in the program. > > > I could have some kind of garbage collection to reuse records. Will that be > faster ? >
Eurico I don't see wasting much time/effort worrying about packing the deletes out - disk is cheap and computers are fast. I agree that the detail transaction data should be in a free table. You can timestamp each swipe, thus creating a transaction history that you can analyze if needed. You do need to be sure that each _issuance_ of the card has a unique ID - in otherwords, when the card is turned in and cleared, the previous transaction is closed out and the next swipe of the card generates a whole new sequence. If the cards are pre-printed, then if a card is swiped that does NOT have an open transaction, you generate a new transaction sequence #. The card # plus the transaction # identify the customer/instance, no matter how many times he swipes the card. Anyway, it matters little whether you clear/pack the table daily or weekly (or whenever). Dan Covill _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
