> We just installed our company's POS software recently at a large
> resort. I
> posted about this project recently in this list. I was so
> pleased with some
> news that I received today, that I thought it appropriate to share it with
> the list.
>
> Right now is a very busy time at this client site because of a
> yearly event
> taking place at this resort which is very popular. This site has:
>
> * FB1.5 On 2Ghz P4, SCSI, 1 Gig RAM running on Win2003.
> * 35 POS terminals positioned around the property at various bar,
> restaurant
> and kiosk profit centers.
>
> Networking (believe it not) is 10/100 Cat 5 and some of the runs
> are pretty
> long. Personally, I thought they should have gone with Fiber...
>
> At any rate, today was one of the busiest days of the year. There was a
> over 18,000 sales transactions posted today and the system didn't even
> blink! To me, that is an incredible amount of data/activity.
> Just imagine;
> each sale involves an average of say, 5 line items for over 90,000
> additional inserts. And that is not even counting database activity for
> discounts, voids, employee clock ins, back office work and reporting,
> payment tenders and all the other peripheral activity including
> thousands of
> selects to present data to the users through touch screen GUI.
>
> I'm smiling like a cheshire cat....
>
> Thanks for a great product.
>
> Warm Regards,
>
> Lee

This is very good news.. I was also just thinking that with Int64 PKs, and
at this possible peak of traffic (90k transactions per day or 6.5m per year)
continuously instead of peak, you have a life in the database of
1,418,980,313,360 years
Hope the client is happy with that - Maybe they will think of enlarging the
system a little, they could afford to shorten it's life by a few billion
years.
Alan