On my primary hub this morning I found that my data engine queue was fairly large. now I am also finding that my transactionlog.db is about 4 GB. I would like to find out what causes it and how I can clean it up.
Is any data at all being inserted into the database? You should check your data_engine, hub and nas logs.
This could be a flood of events that are either dropped in a profile or duplicates. Try using the SQLite browser to select a sample and see what is going on. You could also try putting on flood supression in the nas or, if you can get an idea where it is coming from, at selected robots.