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.
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? -- Christophe Leske www.multimedial.de - [EMAIL PROTECTED] http://www.linkedin.com/in/multimedial Lessingstr. 5 - 40227 Duesseldorf - Germany 0211 261 32 12 - 0177 249 70 31 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
