On Thu, May 8, 2008 at 7:08 AM, D. Richard Hipp <[EMAIL PROTECTED]> wrote:
>
> On May 8, 2008, at 2:54 AM, C M wrote:
>
>> How likely (or possible) is it to corrupt or in some way screw up an
>> SQlite database if one is doing an UPDATE and it fails? (computer goes
>> out, etc.) Thank you.\
>
>
On Fri, 9 May 2008 09:09:03 -0500, "Jay A. Kreibich" <[EMAIL PROTECTED]>
said:
> On Thu, May 08, 2008 at 11:39:17AM -0700, [EMAIL PROTECTED] scratched
> on the wall:
> > If I run the following code I get some unexpected results:
> >
> >sqlite3* db1_p = 0;
> >const
Look at the page_size pragma. I believe SQLite always reads/writes in
page_size chunks. You might also want to adjust cache_size.
http://sqlite.org/pragma.html
--Bob
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf
On 5/9/08, Beverly Seavey <[EMAIL PROTECTED]> wrote:
> Beverly Seavey wrote:
> > I have tried to import data from a file in the same directory. I
> > have tried leaving out the primary ley
> > value in the file, giving the complete path of the text file, quoting
> > the text file,
On Fri, May 9, 2008 at 10:27 AM, Beverly Seavey <[EMAIL PROTECTED]> wrote:
> Beverly Seavey wrote:
>> I have tried to import data from a file in the same directory. I
>> have tried leaving out the primary ley
>> value in the file, giving the complete path of the text file, quoting
>> the text
Beverly Seavey wrote:
> I have tried to import data from a file in the same directory. I
> have tried leaving out the primary ley
> value in the file, giving the complete path of the text file, quoting
> the text file, explicitly changing the separator...
> I can type in a record just fine.
Hello!
I'm working on a project using sqlite3 together with the uClinux +
arm7 + lpc2468. the whole process of reading / writing is very slow,
I wonder if someone knows a way to change the size of the blocks read /
write to sqlite. someone has suggestions to improve the performance
of
you need to put your question into context. The question in its current form is
to generic to give an answer or even try.
Are you having problems with the default block size?
Only you can really determine the correct size based upon your application and
system.
Jorge Pereira <[EMAIL
you need to put your question into context. The question in its current form is
to generic to give an answer or even try.
Are you having problems with the default block size?
Only you can really determine the correct size based upon your application and
system.
Jorge Pereira <[EMAIL
hy folks!
anybody known for use specific size of block to write/read?
thkz!
--
Regards,
++
Jorge Pereira, From: Olinda/Pernambuco/Brazil
Blog: http://www.jorgepereira.com.br/
E-mail: [EMAIL PROTECTED], [EMAIL
I have tried to import data from a file in the same directory. I have
tried leaving out the primary ley
value in the file, giving the complete path of the text file, quoting
the text file, explicitly changing the separator...
I can type in a record just fine. Why can't I get .import to
On Thu, May 08, 2008 at 11:39:17AM -0700, [EMAIL PROTECTED] scratched on the
wall:
> If I run the following code I get some unexpected results:
>
>sqlite3* db1_p = 0;
>const int open1Res = sqlite3_open16(L"test.db", _p);
>sqlite3* db2_p = 0;
>
hy folks!
anybody known that for use specific size of block to write/read?
thkz!
--
Regards,
++
Jorge Pereira, From: Olinda/Pernambuco/Brazil
Blog: http://www.jorgepereira.com.br/
E-mail: [EMAIL PROTECTED], [EMAIL
13 matches
Mail list logo