went with it... I'll look into this more and
consider changing it in our code.
-- William Hachfeld
Quite right Thomas and Jolan! I knew it was going to be something stupid on my
part. If I change the field "column" to "clumn" it works just fine.
Thanks!
-- William Hachfeld
,
file INTEGER, line INTEGER, column INTEGER);
SQL error: near "column": syntax error
sqlite>
In the above, "tmp.db" did not exist prior to the execution of "sqlite3". Where
is the syntax error near "column" in the last line?
-- William Hachfeld
everything succeeds and then being dumbfounded later when
things break in mysterious ways.
-- William Hachfeld
eries).
So my conclusion from all of this is that I need to do one of two things. I
either need to group my queries together and bracket them with a transaction,
or I need to try the suggestion yesterday of disabling the locking.
-- William Hachfeld
suggestion, Ted. I think I'll try this out. If nothing
else, this will help confirm whether the majority of the slowdown is due to NFS
locking performance.
-- William Hachfeld
like
> postgres or mysql.
Nope. that isn't going to be an option for me. Preserving the "zero
configuration" and "single file" environment is of utmost importance in our
application.
Sounds like I'm pretty much stuck.
-- William Hachfeld
;
> <http://www.mail-archive.com/sqlite-users@sqlite.org/>
I did. Almost all of the posts seemed to relate to the correctness of the NFS
locking and how it could be improved. I really don't care so much about correct
locking for our application. I'm more worried about the performance.
-- William Hachfeld
r
> network to ensure there was no collision with another process.
>
> Doing anything over a network is not good for performance.
And because I used a transaction on the insert, the lock only has to be
obtained once, and thus does not significantly affect performance?
--
William Hach
s query performance in general.
The absolute numbers in this test case are artifically low because I'm forcing
a full table scan by querying on a non-indexed field. My concern is with the
relative performance between local versus NFS file systems.
Thanks guys!
-- William Hachfeld
#in
ase, end);
Seem reasonable?
-- William Hachfeld
e
computation on "begin" using 64-bit quantities.
--
William Hachfeld ([EMAIL PROTECTED], 651-683-3103)
SGI Compilers & Tools
would try to convert them from text to integer
and then have the same sort of problem...
-- William Hachfeld
question is
simply this. Does anyone have an idea how I can store a 64-bit unsigned integer
in an SQLite column and still perform useful arithmetic and conditional
operators on them? Thanks in advance for any ideas!
-- William Hachfeld
;
given a large (~1,000,000 rows) table? Is the cost of creating the temporary
table for the compound SELECT usually going to outweigh the benefit of using a
second index? Is there any way to force the temporary table to be placed in
main memory rather than on disk?
--
William Hachfeld ([EMAIL PROTECTED], 651-683-3103)
SGI Debugger, Object, and Performance Tools
does under various
permutations of the query.
--
William Hachfeld ([EMAIL PROTECTED], 651-683-3103)
SGI Debugger, Object, and Performance Tools
N Example (group)
CREATE INDEX IntervalIndex ON Example (begin, end)
And if so, can any generalizations be made regarding the performance of using
the two indicies versus the first, single, index? How about disk usage?
Thanks in advance for any information regarding the above!
-- William Hachfeld
17 matches
Mail list logo
