This place has done close to a million dollars of sales in one month, so I personally think they've outgrown the whole program. The owner recently grumbled about needing a simpler way to look back at sales data from the last three years. We've tried wiping ALL sales records from the database, but they quickly outgrow the 2GB limit.

A purge takes it down to about 500MB, but by the end of the summer season it's crashed into the limits again. At the first location, the database grows to well over 2GB in the space of months.I saw a post earlier about clearing out huge databases, but that raises another problem: many times, the owners/managers want to look back further than the purge. Lately I've gone diving into the abyss that is SQL and the MS Jet/Access database that Aldelo is built on. I work for a POS dealer that sold Aldelo systems for a long time, and in the few years that I've been there I have learned a lot. I may be asking for the impossible, or just asking in the wrong place, but here goes.