[sqlite] sqlite3: sqlite3_step() return SQLITE_FULL error.

On 5/12/15, Deepak Hegde wrote: > Hi everyone, > > I am facing a issue and details are as below: > > 1) Database table have around 15 table. One of the table have around > 66000 entries and this table have about 25 columns. > 2) This table with 66000 entry have field called TITLE with TEXT type >

[sqlite] System.Data.SQLite, Virtual Tables, and ThreadAbortException Issues

Mike Nicolino wrote: > > The issue is isolated to ThreadAbortException since you can't catch it and > prevent it from being re-thrown. I did find a 'fix' for a similar issue > in SystemData.SQLite back on 10/11/2012: > Thanks for the excellent analysis of the issue. I believe you are

[sqlite] emptying tables

On 12 May 2015, at 6:25pm, Zaumseil Ren? wrote: > It was no great difference. And without auto_vacuum I can not shrink the file. You turn off auto_vacuum but do a manual VACUUM once you've deleted all the data from /all/ the tables. It's faster before VACUUM takes time roughly proportional

[sqlite] Multiple connections and page cache(s) reusability

Hello, I have a question regarding caching mechanism in SQLite. Especially when using multiple connections. My understanding was that each connection has its own page cache (if I don't use SQLITE_OPEN_SHAREDCACHE). However I wrote some tests and results didn't met my expectations... So what I

[sqlite] emptying tables

Are you running all your delete statements within a single transaction, or a separate transaction for each? > -Original Message- > From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users- > bounces at mailinglists.sqlite.org] On Behalf Of Zaumseil Ren? > Sent:

[sqlite] emptying tables

>> I have used auto_commit as a replacement for vacuum. Because I only add new >> data and only delete from the end I thought it would be faster (no extra >> scan to rebuild ). > >Humor me. Try your experiment without auto_vacuum. Leave everything >else the same. See what performance difference

[sqlite] TCL tests

On Tue, May 12, 2015 at 5:14 PM, Richard Hipp wrote: > > > ./testfixture NAMEOFFILE.test > testfixture.exe NAMEOFFILE.test > > Respectively for unix and windows. > > Thanks! That helped a lot.

[sqlite] TCL tests

On Tue, May 12, 2015 at 5:05 PM, Richard Hipp wrote: > > > Did you try the commands provided above? > > > yeah I tried those commands and installed both tcl and sqlite but i need help in executing the .test file which requires tcl like the one I attached in this mail. pfa.

[sqlite] TCL tests

On Tue, May 12, 2015 at 4:36 PM, Richard Hipp wrote: > > Unix: ./configure; make test > > Windows: nmake /f makefile.msc test > I installed both tcl and sqlite but i need help to run .test files which are present in test folder for sqlite!

[sqlite] sqlite3 .dump

On 5/12/15, Peter Haworth wrote: > Couple of questions regarding the above command. > > Why does the above command include a PRAGMA foreign_keys=OFF command? So that the script generator does not have to carefully arrange the order of the INSERT statements to avoid a foreign key constraint

[sqlite] VBA Sqllite blob data

Hi Preston, my last suggestion to try to expand the variable size on vba side of sqliteforexcel is really not worth it. Looks like it have been taken care of already (well, sort of). https://sqliteforexcel.codeplex.com/discussions/266048 If I understand this right you will get a byte array when

[sqlite] sqlite3 .dump

Couple of questions regarding the above command. Why does the above command include a PRAGMA foreign_keys=OFF command? Wouldn't it make more sense for the CREATE commands to include IF NOT EXISTS? Pete lcSQL Software Home of lcStackBrowser

[sqlite] TCL tests

But when I tried to run the following message/error pops up : invalid command name "sqlite3_test_control_pending_byte" while executing "sqlite3_test_control_pending_byte 0x001" (file "./tester.tcl" line 92) invoked from within "source $testdir/tester.tcl" (file "attach.test"

[sqlite] TCL tests

Can anyone kindly help me how to compile and run TCL test scripts ? All the test scripts are .test files and I need help in executing them.

[sqlite] emptying tables

>I think that operation will go MUCH faster if you (1) turn off >auto_vacuum, (2) use journal_mode=DELETE, and (3) put all of the >DELETE operations inside a single transaction. > >D. Richard Hipp I have used auto_commit as a replacement for vacuum. Because I only add new data and only delete

[sqlite] emptying tables

Here some last test data PRAGMA synchronous = 1; PRAGMA auto_vacuum = FULL; PRAGMA journal_mode = WAL; PRAGMA wal_autocheckpoint = 1; PRAGMA cache_size = 1; A database ca. 4GB with 2200 tables takes 3 minutes for a "delete * from table" over all tables. HTH Rene Kernkraftwerk

[sqlite] emptying tables

>> My main problem is still the time of a delete statement. It takes some >> minutes to delete all data from all tables. > >How many tables do you have ? You are using just the command > I have up to 3000 Tables. Most of them have only some entries. But some can have have up to a million.

[sqlite] emptying tables

On 12 May 2015, at 9:33am, Zaumseil Ren? wrote: > My main problem is still the time of a delete statement. It takes some > minutes to delete all data from all tables. How many tables do you have ? You are using just the command DELETE FROM myTable with WHERE clause ? > May be it is also a

[sqlite] VBA Sqllite blob data

On Tue, May 12, 2015 at 7:41 AM, Preston King wrote: > I have been able to use SQLite2009 Pro Management Studio to export the > specific record from the DB3 file into Excel without any issues, the entire > record appears correctly. I was trying to create VBA code within Excel to > do the same

[sqlite] TCL tests

Hi Sairam, Hm, Hi Sairam, You should perhaps consult http://www.sqlite.org/tclsqlite.html as it describes the Tcl interface and the way to run the tests. Regards, Arjen > -Original Message- > From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users- > bounces at

[sqlite] emptying tables

Sorry for the delay. >> I started with the single table solution. But it was to slow on select and >> the database was also bigger because of the id for each row. Now I can use >> the timestamp as rowed. > >If it was slow on SELECT I suspect you didn't have an appropriate INDEX. But >my

[sqlite] emptying tables

On 5/12/15, Zaumseil Ren? wrote: >>I think that operation will go MUCH faster if you (1) turn off >>auto_vacuum, (2) use journal_mode=DELETE, and (3) put all of the >>DELETE operations inside a single transaction. >> >>D. Richard Hipp > > I have used auto_commit as a replacement for vacuum.

[sqlite] emptying tables

On 5/12/15, Zaumseil Ren? wrote: > Here some last test data > > PRAGMA synchronous = 1; > PRAGMA auto_vacuum = FULL; > PRAGMA journal_mode = WAL; > PRAGMA wal_autocheckpoint = 1; > PRAGMA cache_size = 1; > > A database ca. 4GB with 2200 tables takes 3 minutes for a "delete * from > table"

[sqlite] TCL tests

On 5/12/15, Sairam Gaddam wrote: > On Tue, May 12, 2015 at 5:05 PM, Richard Hipp wrote: >> >> >> Did you try the commands provided above? >> >> >> yeah I tried those commands and installed both tcl and sqlite but i need > help in executing the .test file which requires tcl like the one I

[sqlite] VBA Sqllite blob data

I have been able to use SQLite2009 Pro Management Studio to export the specific record from the DB3 file into Excel without any issues, the entire record appears correctly. I was trying to create VBA code within Excel to do the same thing. The blob record is a form of html code, it doesn't

[sqlite] TCL tests

On 5/12/15, Sairam Gaddam wrote: > On Tue, May 12, 2015 at 4:36 PM, Richard Hipp wrote: > >> >> Unix: ./configure; make test >> >> Windows: nmake /f makefile.msc test >> > > I installed both tcl and sqlite but i need help to run .test files which > are present in test folder for sqlite! Did

[sqlite] TCL tests

On 5/12/15, Sairam Gaddam wrote: > Can anyone kindly help me how to compile and run TCL test scripts ? > All the test scripts are .test files and I need help in executing them. Unix: ./configure; make test Windows: nmake /f makefile.msc test -- D. Richard Hipp drh at sqlite.org

[sqlite] TCL tests

Hi Sairam, That ought to be easy: tclsh name-of-test-file.test You will need an installation of Tcl, but these are easy to find. One place is at ActiveState's site, www.activestate.com/activetcl, but it may be that you already have it on your

[sqlite] Suggestion for .import improvement

On Mon, 11 May 2015 22:24:53 +0300 wrote: > Current .import behavior is that when the imported table does not > exist, it will be created using the first row from the data file as > column names for the new table. Huh, somehow I'd forgotten that! > Once the initial table is created by the

[sqlite] Fwd: bulk upload from Excel

-- Forwarded message -- From: "maksood alam" <786maks...@gmail.com> Date: May 11, 2015 11:21 AM Subject: bulk upload from Excel To: Cc: Hi Team, Do we have any option like below for the bulk upload. INSERT INTO tbl_test1 SELECT * FROM [asd$] IN '" & ThisWorkbook.FullName & "'