Quote:
Originally Posted by Stefan
Hmmm tried the "vacuum" command? (make a backup first) I've heard it should help but have never tried.
|
It's not a problem as my database is only 1.5 MB, but I tried this anyway and received this error:
Quote:
too many attached databases - max 0
|
On a related note, at various times over the past week there's been some very abnormal serverside lag, where a Database NPC would be listed as 5 - 10% in RC /stats, which seems to be caused by SQLite queries immediately following eachother.
An example of an executed query happening in these instances:
PHP Code:
temp.query = "UPDATE tablename SET examplevalue = examplevalue + " @ float(temp.amtstring) @ " WHERE examplevalue2 = '" @ temp.item.escape() @ "'";
What's surprising is that this simple query is affecting a table which contains only 2 rows, 4 columns, with the necessary value being indexed. I have other SQLite tables with thousands of entries where queries are executing quickly and not causing bizarre lag spikes.