Re: [sqlite] Importing ~1000 CSV files faster

> I'm running the following script on more than 1000 2MB CSV files and I'd > like to speed it up if possible. I noticed that a 'WAL' is running. Is there > something better I can do to improve this process? Use an SSD. John ___ sqlite-users mailing

Re: [sqlite] FW: Bug in division?

> Interesting. It makes NO sense to return 0 when dividing two integers. > Never took a C/C++ class? John ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] FW: Bug in division?

> Any reason I haven't heard back about this bug? You did not get the rest of the discussion on your post? It is not a bug but an implementation allowed behavior and has to do with integer division. John ___ sqlite-users mailing list

Re: [sqlite] Bug in sqlite3.exe?

On Tue, Sep 24, 2013 at 12:53 PM, Staffan Tylen wrote: > Well, it's not my database I'm looking at. What puzzles me is that Country > Languages works but Country Official Languages doesn't, so could there be a > parsing problem? > > I think I see what is happening.. when

Re: [sqlite] Bug in sqlite3.exe?

On Tue, Sep 24, 2013 at 12:35 PM, Staffan Tylen wrote: > SQLite version 3.7.16.2 2013-04-12 11:52:43 > Enter ".help" for instructions > Enter SQL statements terminated with a ";" > sqlite> .tables > CityCountry Languages > Country

Re: [sqlite] Bug in sqlite3.exe?

On Tue, Sep 24, 2013 at 12:35 PM, Staffan Tylen wrote: > SQLite version 3.7.16.2 2013-04-12 11:52:43 > Enter ".help" for instructions > Enter SQL statements terminated with a ";" > sqlite> .tables > CityCountry Languages > Country

Re: [sqlite] Deletion slow?

On Tue, Feb 5, 2013 at 7:54 AM, Jason Gauthier wrote: > Hey Everyone, > > I am a fairly new user of sqlite, but not particularly new to SQL > principles. I am developing an application that will run on a low end system. > Not quite embedded, but not quite a PC. In my

Re: [sqlite] VC++ and SQLite

On Tue, Nov 13, 2012 at 10:29 AM, Arbol One wrote: > Further inspection showed that there is a macro that is added, and not the > stdafx.h file name, the macro is > '%(PrecompiledHeaderFile);%(ForcedIncludeFiles)'. Nevertheless, VS10 still > complains with the following

Re: [sqlite] VC++ and SQLite

On Tue, Nov 13, 2012 at 8:51 AM, Arbol One wrote: > Following the advice of MSN: > Open the project's Property Pages dialog box. For details, see Setting Visual > C++ Project Properties. > Click the C/C++ folder. > Click the Advanced property page. > Modify the Force Includes

Re: [sqlite] VC++ and SQLite

On Mon, Nov 12, 2012 at 1:52 PM, Doug Nebeker wrote: > You might be surprised at the speed increase you see in compile time if > you've got large projects. The time isn't lost to CPU as much, but disk I/O > time adds up when hitting many hundreds of small (header) files

Re: [sqlite] VC++ and SQLite

>> I know this question is not a SQLite question, but I am hoping that >> someone here has had a similar experience and/or can point me to the right >> place to ask this question. >> >> After years or using Code::Blocks and Dev-Cpp, I have recently installed >> Visual Studio 10 Express; it is the

Re: [sqlite] Problem with including sqlite3.c into c++ project

On Mon, Jun 25, 2012 at 4:15 PM, deltagam...@gmx.net wrote: > Hello, > > Im using MSVS 2010 for an c++ GUI project. > After including sqlite3.h and sqlite3.c from the amalgamation-3071200 > and with the Project Properties--> C/C++  --> Precompiled Headers --> > Precompiled

Re: [sqlite] SQLite and C++

On Wed, Jun 13, 2012 at 7:21 AM, Arbol One wrote: > Anyone knows where I can find some examples of how C++ interfaces with > SQLite? I just need to see some code that is functional and not just some > snips of how it maybe-should-possibly work. Although this is

Re: [sqlite] Disk file size

On Wed, Jun 6, 2012 at 7:42 AM, vallur raghava reddy wrote: > Hi, >     I have created a database "MyDb.db" and created a table MyTable using > the query *create table MyTable (id INTEGER PRIMARY KEY, value > CHARACTER(10))* and inserted 3000 records in the table.I

Re: [sqlite] SQLITE3 64-bit version

> Would you know if SQLITE3 can be compiled (and if it will work) as a 64-bit > DLL? > I use SQLITE as a 64 bit dll on windows. However for me it is included with the Qt library. John ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] What do people think of SQLite Root?

> Download the latest version Sqlite Root 1.9.7.6 > BTW, if you press Help then log in windows 7 using that version I get a crash as well. Traceback Info: Traceback (most recent call last): File "core.pyo", line 2481, in actionLog File "framelog.pyo",

Re: [sqlite] Manual

On Sat, Mar 3, 2012 at 10:15 AM, Mark Schonewille wrote: > Hi, > > MySQL has a really great manual with extensive explanations and dozens of > examples for each command. SQLite is none of all this. It just has a limited > number of pages listing a small number

Re: [sqlite] Column names including spaces

>  For example if I "SELECT Col 1 FROM..." I get a "syntax error near 1" > (which I'd expect).  If I try 'SELECT "CoL 1" FROM...", I get and error "no > such column "Col1" - notice there is no space in the column name listed in > the error message". > Are you escaping the quotes for whatever

Re: [sqlite] Newbie question on Data Source

On Mon, Nov 28, 2011 at 5:13 PM, Dave wrote: > > > On 11/28/2011 3:59 PM, Igor Tandetnik wrote: >> >> On 11/28/2011 4:52 PM, Dave wrote: >>> >>> I am trying to learn VB.Net and SQLite at the same time. I have used VB6 >>> Classic in the past. I have VB Studio 2010 Pro and am

Re: [sqlite] How about a proper forum rather than an e-mail list

> If the mailing list was replaced by a forum, everybody would go to the forum. > The failure in this logic is that is not true. I already said I would not bother with the forum and I was not the only one. John ___ sqlite-users mailing list

Re: [sqlite] FW: How about a proper forum rather than an e-mail list

My biggest reason for wanting a mailing list versus a forum is that I subscribe to 20+ mailing lists that all go to my gmail account with gmail rules to organize the content. If these mailing lists all were forums I would not bother with most of them since that would be a lot of work to check

Re: [sqlite] SQLite3.dll for Win 64

On Mon, Jul 25, 2011 at 10:52 AM, Everton Vieira wrote: > So far so good but return an error: > > C:\Dattna\Applications\Installs\sqlite\sqlite-src-3070701>nmake -f > Makefile.msc sqlite3.dll > > Microsoft (R) Program Maintenance Utility Version 10.00.30319.01 > Copyright (C)

Re: [sqlite] What happens if you insert more than your RAM size into an in memory database?

> What happens if you insert more than your RAM size into an in memory > database? > (I'm particularly interested in the Windows context). > Are we talking about 32bit windows? I mean under 32 bit windows the normal address space limit (without the /3GB switch and LARGEADDRESSAWARE link flag) is

Re: [sqlite] Sqlite management

On Sat, Feb 5, 2011 at 6:36 AM, mustafa wrote: > Hello, > > I am planning to write an open source software with wxWidgets > to simplify SQLite operations(select,insert etc) > > There are open source alternative softwares. > http://sourceforge.net/projects/sqlitemanager/ > > >

Re: [sqlite] how to speed up this ?

On Thu, Dec 23, 2010 at 4:06 PM, Vander Clock Stephane wrote: > that very very much expensive :( how much you thing ? > $500 to $600 US. John ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] how to speed up this ?

> i m affraid so ... but what it's will be with 50 000 000 rows ? i don't > have 100 gigabytes of memory :( I would get a 256GB SSD. John ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Windows performance problems associated with malloc()

On Fri, Dec 17, 2010 at 3:12 PM, Richard Hipp <d...@sqlite.org> wrote: > On Fri, Dec 17, 2010 at 2:27 PM, John Drescher <dresche...@gmail.com> wrote: > >> > >> > I'm unable to run your sqlite3.exe: MSVCR100.dll no found. >> > >> That is visual st

Re: [sqlite] Windows performance problems associated with malloc()

> > I'm unable to run your sqlite3.exe: MSVCR100.dll no found. > That is visual studio 2010 runtime. John ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Run Time Error #1 in VS2008

On Sat, Oct 9, 2010 at 12:25 PM, wrote: > I am working on a project in VS2008 and I am including the sqlite3 code > directly (compared to in the past using wrappers).  The program is working > great  (accessing DB, using calls, etc) but I have hit a peculiar issue >

[sqlite] Temporary views across attached databases

I see that normal views across attached databases do not work but it looks like I can create a temporary view across attached databases. Is this a supported configuration? I want to make sure before I put this in my application. -- John M. Drescher ___

Re: [sqlite] Sqlite Insert Speed Optimization

> Thanks for all the feedback! > > It helped a lot. > 1. I'm going to try and see what happen if I leave the "end transaction" > until 5 insert was done. This is what I meant also when I said 500 was too small. John ___ sqlite-users mailing list

Re: [sqlite] Compiling as part of MFC C++ project

>> What do I need to do to get sqlite3.c to compile in a MFC C++ project >> (Visual C++)? If I just add it to the project, I end up getting a >> compile error something like: "Unexpected end of file while searching >> for pre-compiled header directive". >> > > This is a basic Visual C++ question.

Re: [sqlite] Compiling as part of MFC C++ project

> What do I need to do to get sqlite3.c to compile in a MFC C++ project > (Visual C++)? If I just add it to the project, I end up getting a > compile error something like: "Unexpected end of file while searching > for pre-compiled header directive". > This is a basic Visual C++ question.

Re: [sqlite] Sqlite Insert Speed Optimization

On Tue, Jul 13, 2010 at 12:48 PM, John Drescher <dresche...@gmail.com> wrote: >> I was wondering if that's really so.  Wouldn't the marginal speed >> improvement be quite small?  Is the percentage of the final rowcount really >> a criterion? > > Each transaction cos

Re: [sqlite] Sqlite Insert Speed Optimization

> I was wondering if that's really so.  Wouldn't the marginal speed improvement > be quite small?  Is the percentage of the final rowcount really a criterion? Each transaction costs at least 1 disk seek. Doing thousands of seeks the result would be very slow. John

Re: [sqlite] Sqlite Insert Speed Optimization

> I also wrap my statements (about 500 inserts at a time) with a begin/end > transaction. > After these 500 i take a few seconds to read more data so sqlite should > have time to do any housekeeping it might need. > Wrap more into a transaction. 500 is too small of a percentage of a million.

Re: [sqlite] how can i unsubscribe from this forum?

Follow the link at the bottom of each message. On Thu, Jul 8, 2010 at 12:54 AM, Ravi Kiran wrote: > -- > Best Regards, > Ravi > ___ > sqlite-users mailing list > sqlite-users@sqlite.org >

Re: [sqlite] Fw: SQLite and Windows 7

>> in the near future we will implement windows 7. My question: Is >> SQLite running on windows 7? >> I have been using sqlite under windows 7 for at least 8 months without a single issue. John ___ sqlite-users mailing list sqlite-users@sqlite.org