PRAGMA optimize; == no busy handler?

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
21 messages Options
12
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>
</div>
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
12