Thom Ericson wrote:
I had hoped to be able to handle 180,000,000 rows in my largest
installation (that's gonna take a
while). Any hints from anyone
IMHO 180 mln rows is no small deal even for a big database - especially
considering you have got text column in it.
If you are trying to
Nemanja Corlija wrote:
On 4/3/06, Alex Chudnovsky <[EMAIL PROTECTED]> wrote:
Is it possible (if so how) to programmatically determine version of
sqlite that is in use?
SELECT sqlite_version();
Perfect answer, thank you very much!
Also thanks to Boris and Jay (that
Is it possible (if so how) to programmatically determine version of
sqlite that is in use?
Ie something like this: select @@version
The reason I ask is because I have some .NET code that uses Mono as
run-time, and it seems that in some cases Mono picks some other sqlite
DLL than the one
of inserted rows, so instead of: DELETE + INSERTS, you will
have INSERTS + UPDATE. You will need to truncate table once in a while
or even drop/create it.
--
regards,
Alex Chudnovsky
Majestic-12: Distributed Search Engine
http://www.majestic12.co.uk
D. Richard Hipp wrote:
Actually, this seems like a good opportunity to repeat my
oft-ignored advice to not use more than one thread in a single
address space. If you need multiple threads, create multiple
processes.
I think its not really an acceptable option for those who are on Windows
Gé Weijers wrote:
No, sqlite3 uses database-level locking, either one process can
write, or many processes can read. Good enough for most embedded uses.
Any plans for internal queueing of queries waiting for their turn to
write rather than just return database locked?
I did implement
William Hachfeld wrote:
On Thu, Mar 31, 2005 at 12:07:22PM -0800, Jay wrote:
I suppose I could convert the unsigned address into a string. But
UINT64_MAX
(2^64 - 1) is:
18,446,744,073,709,551,615
which, without the commas, would require 20 bytes to store. Quite a bit more
than the 8 bytes
D. Richard Hipp wrote:
Can nobody give me a use case where it is important
to know what the originating column for a result set value is?
Any wrapped or API that loads row values into a hash, and if some
columns have
exactly the same names then they would overwrite information in the
hash.
Edward Macnaghten wrote:
I use column names. I have created a wrapper around sqlite3 (and
other SQL engines) in a developmeny environment I have written to
enable the programmer (or user for that matter) to access an SQL
result set using an object where the property names are the column names.
[EMAIL PROTECTED] wrote:
On Feb 7, 2005, at 9:50 AM, Yogesh Marwaha wrote:
Both threads are using same sqlite connection.
This is your problem.
Each thread should use an isolated connection.
Correct me if I am wrong but I was under the impression that having 2
separate
connections to database
Clay Dowling wrote:
Alex Chudnovsky said:
I am using ADO .NET wrapper
(http://sourceforge.net/projects/adodotnetsqlite/) and I am not sure
if I can just "drop in" new .DLL -- the wrapper was not updated for a
while now :(
I feel moderately bad about that, because I have r
Clay Dowling wrote:
Alex Chudnovsky said:
Today I had database corruption (running v3.0.7 on Windows using ADO
.NET's data providers + my
Alex,
You might try 3.0.8, which is the current stable release from the 3.0
branch. It's entirely possible that you encountered something
Hi all,
Today I had database corruption (running v3.0.7 on Windows using ADO
.NET's data providers + my
anti-locking wrapper on top). All of a sudden queries stopped working
with error returned
being "file is encrypted or is not a database". That sure scared me to
death since
command line tools
Kurt Welgehausen wrote:
It may not be as inefficient as you think, if your host
language is C. [snipped]
Also, if you have a performance problem, you can try
putting indices on test.checksum and buckets.checksum
I think I should have clarified -- it is inefficient from developers
point of view
to
Kurt Welgehausen wrote:
Your update is logically equivalent to this pseudocode:
for every testcs in (select checksum from test) do
update test set id =
(select bucketid from buckets
where buckets.checksum = testcs)
where test.checksum = testcs
You'll
Hi all,
This is my first post here, so I'd like to express thanks to Mr D.
Richard Hipp for creating
such a great small database!
Now here is my question -- it appears that it is not possible to update
table
while doing join with other tables, something I got so used to with
"big" databases.
16 matches
Mail list logo