No. The schema is required to correctly compile the statement, and if the schema changes, then the statement needs to be recompiled.
IOW: The schema, in the version as it existed at prepare time, is an integral part of the prepared statement. -----Ursprüngliche Nachricht----- Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im Auftrag von Lee, Jason Gesendet: Freitag, 05. April 2019 20:08 An: sqlite-users@mailinglists.sqlite.org Betreff: [EXTERNAL] [sqlite] Prepared Statement Without a Database Instance Hi. Is there any way to create a prepared statement without an associated database instance? I have one fixed insert that I am running on many separate databases that are inserting different data sets, and would like to amortize the cost of compiling the insert if possible. Jason Lee _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users. ___________________________________________ Gunter Hick | Software Engineer | Scientific Games International GmbH | Klitschgasse 2-4, A-1130 Vienna | FN 157284 a, HG Wien, DVR: 0430013 | (O) +43 1 80100 - 0 May be privileged. May be confidential. Please delete if not the addressee. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
