PRAGMA optimize; == no busy handler?

classic Classic list List threaded Threaded
21 messages Options
Reply | Threaded
Open this post in threaded view

Re: PRAGMA optimize; == no busy handler?

Keith Medcalf

This is no different that any other xDBMS that permits access to "row" numbers.

If you fail to tell the database engine that your "rowid" is a persistent meaningful value (and not just the current "row number" of the row in some storage somewhere) then you ought not be surprised if its value changes seemingly at random from one moment to the next.

I believe this is documented for SQLite and for pretty much every other xDBMS and ISAM file access method I've ever seen.

<div>-------- Original message --------</div><div>From: Roman Fleysher <[hidden email]> </div><div>Date:2017-10-06  16:23  (GMT-07:00) </div><div>To: SQLite mailing list <[hidden email]> </div><div>Subject: Re: [sqlite] PRAGMA optimize; == no busy handler? </div><div>
sqlite-users mailing list
[hidden email]