Posting Rental Inventory Transactions

[David Jondreau]

A few years ago, I built an inventory tracking system for a company that rents equipment for film productions.

I used calculations to determine stock levels, and, now the db is slowing down quite a bit. I'm doing a rebuild and want to move from calculated stock to scripted stock.

I'm ingesting Todd Geist's Transaction demo from DevCon, which is good, but is limited for what I want.

I'm trying to visualize what techniques to use for a Rental inventory system in which the stock levels change at pre ordained days in the future. I don't know if this is possible to do via script, but any ideas are appreciated.

[David Jondreau]

[tap tap tap]

"Is this thing on?"

I think the only way I can do this is to do it halfway. Post to the current day and do unstored calcs for everything in future, any other opinions are welcome.

[AudioFreak]

DJ,

Would archiving records to another table be an option? We have a file that is set up the same way with unstored calcs. Which does slow down after it gets about 60k records. So I scripted a reset of the starting quanity. Then import the records to an archive table.

Michael

[Søren Dyhr]

I have too been in an out of recursive structures etc. to calculate availiability I've found Edohshins smart-ranges until fm8 was much faster than non-equis .... The lots, required in a rental/touring company in the pro end of music business.

This means that I of course have paid attention to Todd's transaction demo, but it occured on the devcon two years later than when I attended last time. But I think that he indeed have a point with the scalability ... but nearer scrutinization havn't it come to yet.

But I think that what Audiofreak here suggest is very valuable, since the indexing is what burdens down such a solution, and honestly has historic data not much to do todays and tomorrows bookings, so every booking no reaching over todays bookings must be stored elsewhere to shorten the whobling back and forth the recursive structure with deep dependencies causes.

--sd