Re: [sqlite] ChangePassword method problem

2011-10-30 Thread Farhan Husain
Ok, so I created a simple program to test the changepassword method. Here it is: using System;using System.IO;using System.Text;using System.Data.SQLite; namespace SQLiteTest{class Program{static void Main(string[] args){// Create an encrypted database

Re: [sqlite] SQLite Expert

2011-10-30 Thread Jean-Christophe Deschamps
On 30 Oct 2011, at 7:50pm, Abair Heart wrote: > Searching the archives implies, that "sqlite expert" hasn't been asked > about. > > Has anyone tried it yet? Is the program safe? time-saving? Give me the $59 and a Windows computer and I'll check it out. Simon. As a long-term fan user of

Re: [sqlite] SQLite Expert

2011-10-30 Thread Simon Slavin
On 30 Oct 2011, at 7:50pm, Abair Heart wrote: > Searching the archives implies, that "sqlite expert" hasn't been asked > about. > > Has anyone tried it yet? Is the program safe? time-saving? Give me the $59 and a Windows computer and I'll check it out. Simon.

[sqlite] SQLite Expert

2011-10-30 Thread Abair Heart
Hi all, Searching the archives implies, that "sqlite expert" hasn't been asked about. Has anyone tried it yet? Is the program safe? time-saving? Thanks for any input. Abair ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Slow inserts with UNIQUE

2011-10-30 Thread Black, Michael (IS)
One more thing...show us the EXPLAIN of your insert. Is sounds like your insert is not using the index for the insert for some reason (buq in sqlite?). You should see #3 in particular for keyinfo(). On 3.7.5 with a unique text column I get this for an insert: sqlite> explain insert into a

Re: [sqlite] Slow inserts with UNIQUE

2011-10-30 Thread Black, Michael (IS)
You need to provide some more info... #1 What version? #2 How long to insert the 1M? #3 What's the average string size? #5 How long to create the index? #6 How long to insert the next 10,000? And your stated problem is simple enough you should be able to create a complete stand-alone