Well, if the statements within your BEGIN TRANSACTION ... COMMIT only really
affects one database (hereafter called the main database) only that database
should be locked.
If you experience otherwise, it could be because:
1. The locking_mode for the databases has been set to EXCLUSIVE (see
[mailto:sqlite-users-boun...@sqlite.org]
On Behalf Of Rich Shepard
Sent: Tuesday, October 26, 2010 10:59 AM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Multiple databases vs. Multiple tables.
On Tue, 26 Oct 2010, Dariusz Matkowski wrote:
> Queries will be done acr
On Tue, 26 Oct 2010, Dariusz Matkowski wrote:
> Queries will be done across the servers to aggregate the content. I am
> concern about the locking mechanism, if I write to the single database and
> I represent the servers as tables I will have no access to read the other
> servers/tables, but if
write into one and
the other ones are open to read.
-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
On Behalf Of Rich Shepard
Sent: Tuesday, October 26, 2010 9:57 AM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Multiple
On Tue, 26 Oct 2010, Dariusz Matkowski wrote:
> Only one user (the browser). The DB is on a device the same place where
> the user (Browser) is. A process will collect the information about the
> servers and their contents and story it to the DB at the same time the
> user may ask for the
-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
On Behalf Of Rich Shepard
Sent: Tuesday, October 26, 2010 9:24 AM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Multiple databases vs. Multiple tables.
On Tue, 26 Oct 2010, Dariusz Matkowski wrote
On Tue, 26 Oct 2010, Dariusz Matkowski wrote:
> in your opinion is it better (performance, maintainability etc...) to
> have multiple databases or multiple tables. The problem I am facing is as
> follows. I have many media servers containing a large amount of images
> music and videos, let's
On Mar 3, 2008, at 12:55 AM, Kee Wee wrote:
>
> I would be very interested to follow-up this subject closely,
> as we are actually performing the same kind of work as you are
> looking for.
>
> One of the answer you got was that it is not possible to reuse a
> prepared
> statement from one
I would be very interested to follow-up this subject closely,
as we are actually performing the same kind of work as you are looking for.
One of the answer you got was that it is not possible to reuse a prepared
statement from one database to another.
This answer was too quick, and did not
"Mina R Waheeb" <[EMAIL PROTECTED]> wrote:
> Hi,
>I have few questions regarding the limitation of multiple databases with
> SQLite.
>
> I have a large number of SQLite DB files with the same structure i
> need to query them all (looking for speed), I have tried ATTACH method
> and its
Thanky Mr. Kees!
This help a lot. This is the way i was thinking too.
I have lot things to do though, i am still learning the sqlite!
Thank you once again!
--
View this message in context:
http://www.nabble.com/multiple-databases-tf4480719.html#a12794210
Sent from the SQLite mailing list
On Thu, 20 Sep 2007 02:03:59 -0700 (PDT), you wrote:
>
>Hello again!
>I was really surprised and relieved to see that so many people replied to my
>question! I really thank you all!
>I would love to come to the conference but i am from Greece.
>I am going to explain in details what i am trying to
Hello again!
I was really surprised and relieved to see that so many people replied to my
question! I really thank you all!
I would love to come to the conference but i am from Greece.
I am going to explain in details what i am trying to do.
I am indeed using the network simulator 2 in order to
[EMAIL PROTECTED] wrote:
There are no SQLite-specific talks or tutorials this year
Well, my talk Thursday afternoon is on using an SQLite database for
storing Tcl/Tk scripts which are used for displaying and modifying
SQLite databases. So although your statement is strictly correct, I
I think that his project is to use simulation software to build a model
of a network in software using a simulation package like NS2. It models
the network by implementing algorithms, not by setting up hardware.
Vitali Lovich wrote:
I think you need to clarify your needs a bit, cause it seems
nadiap wrote:
Hello,
i am a newbie and i would like to ask if it is possible to use sqlite in
order to simulate a wireless network where each node will have each own
database. I mean, can i attach each node to a database? What shall i do? I
am sorry if my question seems naive, but i am just
Most likely if you're simulating networks where there is a db in each node
then you really want to simulate network traffic based on that db protocol.
SQLite is an embedded database that runs in-process and by definition has no
network traffic or protocol (except if you count opening a database
17 matches
Mail list logo