Thanks a lot...forking was the problem..it is working now :)
Roger Binns wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 21/11/11 23:02, gavyas wrote:
I dont understand why I am getting this error.
My best guess would be that a fork is happening after the database has
been
Thanks for the reply,
this thing is that I get this while doing a select operation,
now, I know that I get a lot of results from this select, but I am not
writing anything to my DB explicitly. what am I missing here ?
On unix, you should usually only get SQLITE_IOERR_WRITE if write() returns
-1
On 11/22/2011 04:14 PM, Tal Tabakman wrote:
Thanks for the reply,
this thing is that I get this while doing a select operation,
now, I know that I get a lot of results from this select, but I am not
writing anything to my DB explicitly. what am I missing here ?
Some SELECT need to write to
Do transactions speed up SELECT statements?
--
Programming today is a race between software engineers striving to build
bigger and better idiot-proof programs, and the Universe trying to produce
bigger and better idiots. So far, the Universe is winning. - Rich Cook
On 11/22/2011 04:34 PM, Baruch Burstein wrote:
Do transactions speed up SELECT statements?
They can a bit. If you put 10 SELECT statements in a transaction
SQLite only has to lock and unlock the database file once. If
you run them outside of a transaction the db is locked and unlocked
10
On Mon, 21 Nov 2011 14:01:47 +, Simon Davies
simon.james.dav...@gmail.com wrote:
On 21 November 2011 13:41, SupportLists supportli...@qlands.com wrote:
Hi,
I am trying to use sqlite3 command shell with -init filename.
The file has:
CREATE TABLE griddata (id_suit VARCHAR(14) PRIMARY
I will when I get the chance, but I am trying to get a list of things to
try to improve my SELECT speeds. If it is one SELECT, but returning +-1
rows, it probably won't make a difference, right?
On Tue, Nov 22, 2011 at 11:41 AM, Dan Kennedy danielk1...@gmail.com wrote:
On 11/22/2011 04:34
Greetings all,
It is well known that you cannot create triggers against virtual tables and
fts4 tables are a form of virtual table.
Has anyone developed a work around method for this or simulating the end
effect?
I have a full text search table which is comprised of joining and selecting
from
On 22 Nov 2011, at 10:45am, Baruch Burstein wrote:
I will when I get the chance, but I am trying to get a list of things to
try to improve my SELECT speeds. If it is one SELECT, but returning +-1
rows, it probably won't make a difference, right?
Right. It'll do a lock, then the SELECT,
On 22 Nov 2011, at 5:40am, gavyas wrote:
Its working fine with g++ compiler but not mpicc!!
Good experiment. Well spotted.
Do you have control over the amount of optimization the mpicc compiler does ?
Can you try turning optimization off entirely, or to its lowest setting ?
Simon.
Hello Gaurav,
What does a debugger show you?
C
Tuesday, November 22, 2011, 2:07:38 AM, you wrote:
GV Here is the situation. I am using a cluster on which you can use MPI to
GV split the processing time on to different processors. I was using
GV PostgreSQL but since the data was on different
Use view + triggers on view. Triggers on view can modify FTS4 table
and any other.
2011/11/22 Ephraim Stevens ephraim.stev...@gmail.com:
Greetings all,
It is well known that you cannot create triggers against virtual tables and
fts4 tables are a form of virtual table.
Has anyone developed a
On Nov 21, 7:34 am, Simon Slavin slav...@bigfraud.org wrote:
Are you using a program ? Perhaps one called 'sqlite3.exe' ? If so, this
program needs to be compiled with a version of readline() which understands
non-Roman characters.
Yes, I'm using the MacPorts version of sqlite3, though it
On 11/22/2011 05:45 PM, Baruch Burstein wrote:
I will when I get the chance, but I am trying to get a list of things to
try to improve my SELECT speeds. If it is one SELECT, but returning +-1
rows, it probably won't make a difference, right?
No advantage in wrapping a single statement, of
Hi there,
i have two little questions.
First one, is this valid syntax for a CASE WHEN?
CASE WHEN ( [field1] IS NOT NULL ) AND ( ( [field1] 1 ) OR ( [field1] 0 ) )
In special I mean can I use AND, OR in CASE WHEN.
Second question, I get really strange
On 11/22/2011 11:26 AM, Steffen Mangold wrote:
i have two little questions.
First one, is this valid syntax for a CASE WHEN?
CASE WHEN ( [field1] IS NOT NULL ) AND ( ( [field1] 1 ) OR ( [field1] 0 ) )
In special I mean can I use AND, OR in CASE WHEN.
Yes. You can use any expression. AND
Thanks Taleeb,
That will get me going until the next question. :-)
Dave
On 11/21/2011 11:25 PM, Taleeb Anwar wrote:
Download the x64 mixed-mode assembly compiled statically against the .NET
Framework 3.5 (as you are using VS2010 on a 64 bit computer). Regarding
targetting x86 users you can
Hi Igor,
Yes. You can use any expression. AND and OR are operators, just like + or =
Ok, thank you good to know.
SQLite doesn't have a dedicated time type. There are many ways to store
time values - e.g. as a string '12:34', or as a number of seconds from
midnight.
How exactly do you
Haven't fought with times in sqlite myself, but if everything's being stored as
strings, I suspect what you need to do is use
something like:
strftime(%s,TIME(NOW)) strftime(%s,FIELD1)
That is, convert the complex strings into something that sqlite can reasonably
treat as numbers for the
I insert data in this way (for example):
INSERT INTO [filed1] VALUES TIME('29-01-2011 08:00:00')
Result of TIME('29-01-2011 08:00:00') is NULL. So your field1 doesn't
contain anything. Maybe that's why your comparison doesn't work.
Pavel
On Tue, Nov 22, 2011 at 11:57 AM, Steffen Mangold
On Nov 22, 2011, at 6:44 PM, Pavel Ivanov wrote:
INSERT INTO [filed1] VALUES TIME('29-01-2011 08:00:00')
Result of TIME('29-01-2011 08:00:00') is NULL. So your field1 doesn't
contain anything. Maybe that's why your comparison doesn't work.
As per the fine manual:
Hi Simon, Abhinav and Filip,
On 21/11/2011 11:32 AM, Simon Slavin wrote:
You have to look at the rows it returns and see how many of them there are. If
there's only one, that's your hit. If there are more than one, see how many
characters you can move along the row before they start to be
sqlite select time( '2011-01-29 08:00:00' );
08:00:00
Oh sorry, i looked wrong. I insert this way:
INSERT INTO [filed1] VALUES '2011-01-01 08:00:00'
And because of the init of:
CREATE TABLE tabel1 (
[field1] time,
);
SQLite writes only the time to the database.
But this fails:
On 11/22/2011 2:21 PM, Steffen Mangold wrote:
Oh sorry, i looked wrong. I insert this way:
INSERT INTO [filed1] VALUES '2011-01-01 08:00:00'
And because of the init of:
CREATE TABLE tabel1 (
[field1] time,
);
SQLite writes only the time to the database.
What makes you believe so? To
Ok here the complete example (sorry if I wasn’t clear before):
1. I had a table where I insert some data with a datetime and a value
CREATE TABLE tableA
(
[TimeStamp] datetime,
[Value] varchar
);
2. Now I have a second table where I want save the lowest time insert
On 11/22/2011 3:08 PM, Steffen Mangold wrote:
Ok here the complete example (sorry if I wasn’t clear before):
1. I had a table where I insert some data with a datetime and a value
CREATE TABLE tableA
(
[TimeStamp] datetime,
[Value] varchar
);
2. Now I have a second
Now I fixed it.
CREATE TRIGGER tableA _InsertUpdate
AFTER INSERT
ON tableA
begin
update tableB
set
[LowestTime] = CASE WHEN ( [LowestTime] IS NULL ) OR
([LowestTime] TIME(NEW.TimeStamp)) THEN TIME(NEW.[TimeStamp]) ELSE
[LowestTime] END
end;
... THEN
How come my sqlite can't recognize this statement? It's not showing as
completed and I don't see why.
Using 3.7.9 with default options.
sqlite CREATE TRIGGER tableA _InsertUpdate
... AFTER INSERT
... ON tableA
... begin
...update tableB
...set
...
How come my sqlite can't recognize this statement? It's not showing as
completed and I don't see why.
Maybe there should be semicolon after update statement (i.e. after END
belonging to CASE)?
Pavel
On Tue, Nov 22, 2011 at 3:50 PM, Black, Michael (IS)
michael.bla...@ngc.com wrote:
How
Yup...that's it...thought the example was complete.
Michael D. Black
Senior Scientist
Advanced Analytics Directorate
Advanced GEOINT Solutions Operating Unit
Northrop Grumman Information Systems
From: sqlite-users-boun...@sqlite.org
There is no optimization as of now. I am just slitting the code into
various independent parts. And one more thing I found, I have installed
SQLite3 3.7.9 and when I am using sqlite3_open_v2 it gives error that says
undefined symbol sqlite3_open_v2, and I have linked the correct library.
Gaurav
31 matches
Mail list logo