Christophe Leske wrote: > John Stanton schrieb: > >>The sqlite3.exe program is set up as a utility and maintenance tool, not >>a production environment and is designed to that end. If you want >>maximum performance it is not the way to go; instead embed the Sqlite >>calls inside your application and optimize access. If you are >>performing ad-hoc DB tasks then it or one of the many similar function >>Ssqlite tools are appropriate. One is the Firefox plug in. >> >>You can imagine that having to compile the SQL for over and over instead >>of storing and re-using the compiled code adds considerably to overhead >>on frequently run jobs. > > Yes, but I am using Adobe Director as a production environment. This is > a single threaded application, which also doesn´t allow for threaded > calls to a database. Plus, i got no access to the source code of the > so-called Xtra (=DLL) which emits the call to the DB.
You cab build your own command line interfsce embedding Sqlite. > > All i got is an Xtra which spawns a new thread in which the command line > executable is run. I need the thread in order to keep my application > running smoothly which otherwise stalls. > > Regading the pre-recording of statements: can this be achieved somehow > if the parameters of the call change all the time? This is where sqlite_bind functions. > > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
