2 ms·
For this, could probably dump/replicate to SQLite for archive/backup/point in time... Or one-way replicate for reports.
by tracker1 7y ago
For this, could probably dump/replicate to SQLite for archive/backup/point in time... Or one-way replicate for reports.
- eloff 7y agoI've used this strategy with a read only replica. It also protects the database from long running and inefficient queries. Highly recommend doing this if you have the budget for it.
- amylene 7y agoThis is how PowerBI, from Microsoft, works. It copies the data into local RAM (or on a cloud machine that also runs the dataviz)