On Sun, Apr 16, 2006 at 02:23:45AM -0300, Cesar David Rodas Maldonado wrote:
> On 4/15/06, Cesar David Rodas Maldonado <[EMAIL PROTECTED]> wrote:
> >
> > Hello
> >
> > I have a software that uses four tables.
> >
> > that's ok.. but i wanna know if is faster if i use for every table a
> >
The idea of putting a table per database is a little odd, I expect that
is why you did not get an instant answer.
typically database table are interrelated and therefore need to be
joined to provide useful information. Given that there are some good
reasons why you might want to keep some
First off: SQLite is not made to be scalable. If you are concerned
about performance, use something else.
The only performance issue you need to worry about with memory mapping
is running out of address space. BTW- I don't know about sendfile but
TransmitFile does not need memory mapping.
On
Hello,
I have a table of strings and integer primary keys from which I would like
to retrieve a string at random. The best solution I could think of was to
first do a
SELECT count(id) FROM strings;
and then a
SELECT string FROM strings LIMIT 1 OFFSET ?;
where the parameter is set to an
I wonder if members can help me with some advice. I have a program
which is a multi-threaded application server with Sqlite embedded which
runs on Unix and Windows. For an i/o buffer per thread I have the idea
of using a mmap'd file so that it can be transferred using
sendfile/TransmitFile
[EMAIL PROTECTED] wrote:
These days they teach the Philosophy of Science, and students get to
understand why Mathematicians are awarded Arts not Science degrees.
Although it seems highly pedantic it is actually very important that
programmers have an insight into what they are really doing if
Hello,
I was wondering whether it is safe to read or write a table while
being indexed. Here's a scenario: for batch imports, it's sometimes
better to DROP the indexes, do the INSERTs and then recreate the
relevant indexes. Indexing may take a little bit of time, so I was
wondering if:
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
>
> I think Aaron is working in Mono: how would that work out on
> Linux for connecting to SQLite through DotNet (I presume that
> ADO.Net is Windows only!); I was suggesting that he convert
> VB code to C# in
[EMAIL PROTECTED] schreef:
If you're using Visual C# Express 2005 (or any 2005 product) then you may
as
well go for broke and learn the ADO.NET 2.0 framework. I wrote/maintain a
fairly decent SQLite ADO.NET 2.0 Provider at http://sqlite.phxsoftware.com
and make myself available on the
> If you're using Visual C# Express 2005 (or any 2005 product) then you may
as
> well go for broke and learn the ADO.NET 2.0 framework. I wrote/maintain a
> fairly decent SQLite ADO.NET 2.0 Provider at http://sqlite.phxsoftware.com
> and make myself available on the forums quite a bit.
>
>
Hello
I have a software that uses four tables.
that's ok.. but i wanna know if is faster if i use for every table a
database ( a file) or if is the same thing in velocity if a put all the
tables in one file, couse every table uses a lot of data.
thanks
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Saturday, April 15, 2006 6:11 AM
> To: sqlite-users@sqlite.org; Aaron Jones
> Subject: Re: [sqlite] Structured or Object-Oriented?
>
> I have not done SQLite work in C#, Java or VB:
> I used Delphi with
Hi Kevin, my Supervisor isn't really a programmer so he may not even know
this, his roots are OO design. Yes I will be using C# (if i have time to
learn it, I have heard it is like Java which I already know, if not I was
going to do it in VB.Net which I also know, and I found a program that
wow. an overload of information for a saturday morning. lol.
I do indeed intend to further my maths and programming knowledge but at the
moment I need to focus solely on the completion of my product and
dissertation for which I only have little over 2 weeks (possibly 5 but this
would eat into
> These days they teach the Philosophy of Science, and students get to
> understand why Mathematicians are awarded Arts not Science degrees.
>
> Although it seems highly pedantic it is actually very important that
> programmers have an insight into what they are really doing if they are
> to
Am 15.4.06 um 02:36 schrieb Paul Nash:
I have taken the plunge and am converting from ver 2.8.16 to ver 3.
I used the .DUMP method but found a problem. My char/text fields
containg numbers were output as pure numbers without the quotes, so
that on input to ver 3 they were stored as
16 matches
Mail list logo