Hi Everyone,
I don't know this was problem or not.
I'm using version 2.8.8.
I have a table with 350 record,
With below Query I got 5 records, (which suppose to be result i want)
SELECT DISTINCT LangNo, MovieSTK FROM VoIS WHERE BranchSMS='GKL1' AND
DateID='2' AND LangNo BETWEEN 1 AND 5 ORDER
On Tue, 2003-12-30 at 06:46, Steve O'Hara wrote:
My understanding is that logically, by their very nature, joins are always
likely to be slower than single table queries - I thought that this was a
given downside to normalisation or am I incorrect? Maybe the downside is
not pronounced in
Roger Reghin wrote:
I managed to compile SQLite (2.8.8) under Linux with the ThreadSafe option
set to 1.
It works, but the file size is twice as big as the original .so from the
SQLite site (without the ThreadSafe portion).
What should I do, or, what I shouldn't do???
1. Run strip to
Hi Kurt. I could use code to parse out the other stuff too.
If its written in C/C++, would you be willing to share it?
cheers
-brett
It's a tcl function that returns a list containing a string,
5 lists of strings, and 3 lists of lists of strings. You'd
have to translate it. It's too long
Hi!
I added these things myself to the Makefile...
TCC = gcc -g -O2 -DTHREADSAFE=1 -DNDEBUG=1
LIBREADLINE = ... -lpthread
Then:
$ make
$ cd .libs
$ strip libsqlite.so.0.8.6
That's all. Now the libsqlite.so file is only 260K (less than half the
last
Hi,
I try to find a ODBC driver to use on linux with OOo.
Can you help me ?
P.S. Sorry for my english.
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Hi!
Danny,
thank you for your answer!! =)
No problem - but it wasn't correct... ;-)
(I should sleep a little ;-))
TCC = gcc -g -O2 -DTHREADSAFE=1 -DNDEBUG=1
The important thing is not only the option -DNDEBUG=1 but
mainly -g ofcourse... -DNDEBUG=1 is a SQLite specific
Danny Reinhold wrote:
TCC = gcc -g -O2 -DTHREADSAFE=1 -DNDEBUG=1
The important thing is not only the option -DNDEBUG=1 but
mainly -g ofcourse... -DNDEBUG=1 is a SQLite specific directive
while -g is a compiler option for the gcc...
Actually, the -DNDEBUG=1 is not SQLite specific.
Hi again,
Actually, the -DNDEBUG=1 is not SQLite specific. This is how
you disable assert()s. The SQLite library is full of assert()s
for sanity checking. But it is smaller and runs twice as fast
if you leave them out.
Oh yes, you are right.
(I forgot it because I don't use assert() very
... are UNIQUE columns basically the same as PRIMARY KEY ...?
No, they're not the same thing.
There are dozens of elementary articles on database
theory on the www. Try a Google search on 'database
primary key' or something like that.
On Dec 30, 2003, at 3:12 PM, Kurt Welgehausen wrote:
... are UNIQUE columns basically the same as PRIMARY KEY ...?
No, they're not the same thing.
I understand that they are not the same thing in SQL. What I want to
know is whether or not applying UNIQUE and PRIMARY KEY amount to the
same
11 matches
Mail list logo
