Prev: Odd CVS revision number
Next: Why isn't stats_temp_directory automatically created?
From: "Omar Bettin" on 25 Feb 2010 16:35
hello to everyone,
is a bit late for an italian, but after an long day debugging I had an idea.
Why not introduce a special SQL command like
STORE WHERE [condition] FROM [table]
removing all data that meet the condition and storing them into another database?
Then, if a query that needs the stored data is executed after such command the database joins the stored data into the result query.
This can keep the production database lightweight and fast.
Regards

Omar Bettin
 | 
Pages: 1
Prev: Odd CVS revision number
Next: Why isn't stats_temp_directory automatically created?