Re: [sqlite] Update Statements using Sub query

You are requesting the field Column Name (with embedded whitestpace in the field name) from a query with a where clause that forces it to be the string 'Date'. Perhaps your are looking for SELECT Date -Ursprüngliche Nachricht- Von: MikeSnow [mailto:michael.sab...@gmail.com]

Re: [sqlite] Fsync or fdatasync performs slowly

Thank you for your response. The disk I mentioned is the hard disk. Fsync is moving data from memory to hard disk. When I removed the hard disk from the box and fsync is still called in sqlite, in this case of course, data will not be moved successfully to hard disk but fsync will still do

Re: [sqlite] Fsync or fdatasync performs slowly

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 01/20/2015 01:12 AM, Wei, Catherine wrote: > What's strange is that when I remove the disk, the difference still > exists. It takes long time for fsync working with no disks, which > has confused me for several days. What exactly do you mean by

Re: [sqlite] Update Statements using Sub query

On 20 January 2015 at 13:09, MikeSnow wrote: > I was wondering if anyone could help > I am trying to use Excel to create update statements based on certain > criteria. > For example...this works > UPDATE CDR_Adjusted SET "DateTime"=DATE||" "||TIME; > (This is

Re: [sqlite] sqlite3 performance on select count very slow for 16 GB file

On 20 Jan 2015, at 12:12pm, Parakkal, Navin S (Software Engineer) wrote: >When I do a select count(*) on hp_table1 it takes more than 5 mins which > is quite a huge time. If this is a table for which rows are inserted but never deleted, then you will find that

[sqlite] Update Statements using Sub query

I was wondering if anyone could help I am trying to use Excel to create update statements based on certain criteria. For example...this works UPDATE CDR_Adjusted SET "DateTime"=DATE||" "||TIME; (This is what I need, a simple Concat 2013-10-11 7:59 But when I try to do this UPDATE

Re: [sqlite] ORDER BY and LIMIT regression

> On 1/19/15, Angelo Mottola converge.it> > wrote: >> Hello, >> >> I have a regression to report, that seems to have been introduced between >> SQLite 3.8.6 and the newest 3.8.8 (at least our test case worked in 3.8.6 >> and stopped working somewhere in 3.8.7.x; we were

[sqlite] sqlite3 performance on select count very slow for 16 GB file

Hello, I've few questions about sqlite3 , the database it creates. Actually I'm finding lot of differences in performance. My story: I have this sqlite3 database called hp.db which is like 100+ million records for table1. The size of hp.db on Linux x64 (CentOS 7) is like 16 GB.

Re: [sqlite] sqlite3 performance on select count very slow for 16 GB file

On 1/20/15, Parakkal, Navin S (Software Engineer) wrote: > Hello, > >I've few questions about sqlite3 , the database it creates. Actually I'm > finding lot of differences in performance. > > My story: > I have this sqlite3 database called hp.db which is like 100+

Re: [sqlite] Fsync or fdatasync performs slowly

The way you mentioned "only involves one long update, not 100 long updates" is good, however, I met the problem in the performance test and found that the results in two kinds of set-up box are in great difference in committing transaction. Maybe it's related to hardware performance. What's