Re: [sqlite] Performance Issue with SQLite Inserts

As mentioned before try with putting all your inserts into begin end block. In that way there is no way to query the file from other proces. Any way check pragma directives ie. make bigger cache size... -- Regards, Michał Zaborowski (TeXXaS) ---

[sqlite] Record number (again)

ike "S%" recno in this example is my function - it is simple counter - if param is > 0. If param is < 0 counter is not incremented. In both cases function returns actual counter. It works as I expect. I would like to know if some one else did somethink like that? Would it work i

[sqlite] Record nuber

and random argument value, but it looks strange... If anyone has better idea... Please let me know. -- Regards Michal Zaborowski (TeXXaS) http://sqlite4delphi.sourceforge.net/ - To unsubscribe, e-mail: [EMAIL PROTECTED] For

Re: [sqlite] Concurrency in SQLite

If shared file - < 1MB. * Do you ever put database files on a shared filesystem? I need it, as I wrote. Right now app works as desktop. The better I understand the problems, the better job I will be able to do in resolving them. Thanks for you responses. > Thank you for your time.

Re: [sqlite] Improving concurrency in SQLite

that. Next aspect is communication betwean transactions. PG has is serials, so every transaction has unique values... It can be done by locking file with the values. All that changes will slow down SQLie ;( It would be nice to allow turnig off. I hope it helps. -- Regards, Michal Zabor

[sqlite] ANN: SQlite4Delphi 0.4.4

Hello, As in topic - new release. Many bugs fixed, better stability. Please test and comment. -- Regards, Michal Zaborowski (TeXXaS) http://sqlite4delphi.sourceforge.net/ - To unsubscribe, e-mail: [EMAIL PROTECTED] For

Re: [sqlite] Performance tuning question

Try with bigger cache size. I think ADO uses bigger cache so it can work longer only in memory. Transactions can help, but in case of many updates/inserts there is not enought space in cache, so the rows are stored on disk. -- Regards Michal Zaborowski (TeXXaS) http

[sqlite] autoindex problem

Hi, I'm trying to get information about autoindex column for specified TABLE. I found something: http://groups.yahoo.com/group/sqlite/message/197 But command: pragma index_info('(TABLE autoindex 1)'); does not return expected information... -- Regards Michal Zaborowsk

Re: [sqlite] Rewriting SQLite APIs to Delphi

ction (SQLite_VM: Integer; var ErrMsg: PChar): Integer; cdecl; For more info, please visit project's development page: http://sourceforge.net/projects/sqlite4delphi -- Regards, Michal Zaborowski (TeXXaS) http://sqlite4delphi.sourc

Re: [sqlite] Performance benchmarking

What about transactions? Are you useing them? -- Regards Michal Zaborowski (TeXXaS) http://sqlite4delphi.sourceforge.net/ - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

[sqlite] How to add new wrapper to Wiki page?

Hi, As in topic. I would like to add http://sqlite4delphi.sourceforge.net/ as new wrapper for Delphi. -- Regards Michal Zaborowski (TeXXaS) http://sqlite4delphi.sourceforge.net/ - To unsubscribe, e-mail: [EMAIL PROTECTED