[sqlite] unsuscribe

2006-05-30 Thread Richard Battagline
unsuscribe

__
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 


Re: [sqlite] Cant find sqlite db from cron

2006-05-30 Thread womble

btw Im using

PECL Module version  2.0-dev $Id: sqlite.c,v 1.166.2.13 2006/04/18 14:30:15
iliaa Exp $  
SQLite Library  2.8.17  
SQLite Encoding  iso8859  

--
View this message in context: 
http://www.nabble.com/Cant+find+sqlite+db+from+cron-t1708143.html#a4637538
Sent from the SQLite forum at Nabble.com.



[sqlite] Cant find sqlite db from cron

2006-05-30 Thread womble

Hi Ive just converted a script from mysql to sqlite using php 5.1.4.

Running the script like..

php script.php

works fine but I need it run from cron, if I do..

10 14 * * * php -q /var/www/html/script.php

It cant find the db file errors like...

Warning: sqlite_query(): no such table: *** in /var/www/htmlscript.php on
line 36

Is there a way to hard code the path to the db file or is there another way
I can write the cron task.

Thanks
--
View this message in context: 
http://www.nabble.com/Cant+find+sqlite+db+from+cron-t1708143.html#a4637521
Sent from the SQLite forum at Nabble.com.



Re: [sqlite] Application errors from upgrading sqlite2-8.13 to sqlite-3.3.5

2006-05-30 Thread drh
"Sleigher, William H." <[EMAIL PROTECTED]> wrote:
> I am using tcl8.4.6 and have upgraded my sqlite from sqlite-2.8-13 to
> sqlite-3.3.5.  I originally tried to update my tcl8.4.6 to tcl8.4.11 and
> could not get my application to run.  I can get my application to come
> up with tcl8.4.6 and the sqlite-3.3.5 with some problems.  After
> changing application calls from sqlite to sqlite3 where needed, the
> application crashes getting a signum 11 error after calling
> sqlite3HashInsert.  I have placed fprintf statements in the
> sqlite3HashInsert, so it gets there, it just doesn't return.  It appears
> that the arguments are correct in calling the sqlite3HashInsert in
> hash.c.  This procedure is called in my application after some parsing
> and detecting a semi-colon.  
> 
>  
> 
> Has anyone experienced problems in their application(s) upgrading to
> sqlite-3.3.5 when making a call to sqlite3HashInsert and if so, is there
> a solution to this problem?
> 

I do not recall any such problem having been seen before.
Did you compile SQLite and the TCL bindings yourself, or are
you using a download from the website?  What other details
can you provide?  Can you show us the schema of the database
and the specific SQL statement that is being executed at
the time of the crash?
--
D. Richard Hipp   <[EMAIL PROTECTED]>



[sqlite] threading vs no threading compilation performance

2006-05-30 Thread Brannon King
For a single-threaded application, is there some performance benefit to
compiling SQLite3 with the THREADSAFE=0 option?  The only thing I do in a
multi-threaded situation is inserts, and I'm wondering if I'm not better off
just multiplexing them myself so that I only have to worry about one
transaction running at any given time.
__
Brannon King
¯¯




Re: [sqlite] SQLite without callback function

2006-05-30 Thread John Stanton

Sorry, sqlite3_bind also.

For the benefit of the original poster the API call which implements a 
callback is implemented with sqlite3_prepare etc.


[EMAIL PROTECTED] wrote:

Have not you forgot the bind ?
Mario Hebert
Legerity



John Stanton <[EMAIL PROTECTED]> 
05/30/2006 04:55 PM

Please respond to
sqlite-users@sqlite.org


To
sqlite-users@sqlite.org
cc

Subject
Re: [sqlite] SQLite without callback function






Use sqlite3_prepare, sqlite3_step, sqlite3_reset and sqlite3_finalize.

[EMAIL PROTECTED] wrote:

I think I know the answer to this but I figured it would be better to 


ask 


than to do a major design flaws. :)

What is the most efficient way in SQLite (using the C/C++ interface 


layer) 

to retrieve the result of a query without using the callback function 
(setting it to NULL) ?


Thanks,

Mario Hebert
Legerity











Re: [sqlite] SQLite without callback function

2006-05-30 Thread Mario . Hebert
Have not you forgot the bind ?
Mario Hebert
Legerity



John Stanton <[EMAIL PROTECTED]> 
05/30/2006 04:55 PM
Please respond to
sqlite-users@sqlite.org


To
sqlite-users@sqlite.org
cc

Subject
Re: [sqlite] SQLite without callback function






Use sqlite3_prepare, sqlite3_step, sqlite3_reset and sqlite3_finalize.

[EMAIL PROTECTED] wrote:
> I think I know the answer to this but I figured it would be better to 
ask 
> than to do a major design flaws. :)
> 
> What is the most efficient way in SQLite (using the C/C++ interface 
layer) 
> to retrieve the result of a query without using the callback function 
> (setting it to NULL) ?
> 
> Thanks,
> 
> Mario Hebert
> Legerity
> 
> 




Re: [sqlite] SQLite without callback function

2006-05-30 Thread John Stanton

Use sqlite3_prepare, sqlite3_step, sqlite3_reset and sqlite3_finalize.

[EMAIL PROTECTED] wrote:
I think I know the answer to this but I figured it would be better to ask 
than to do a major design flaws. :)


What is the most efficient way in SQLite (using the C/C++ interface layer) 
to retrieve the result of a query without using the callback function 
(setting it to NULL) ?


Thanks,

Mario Hebert
Legerity






[sqlite] Application errors from upgrading sqlite2-8.13 to sqlite-3.3.5

2006-05-30 Thread Sleigher, William H.
I am using tcl8.4.6 and have upgraded my sqlite from sqlite-2.8-13 to
sqlite-3.3.5.  I originally tried to update my tcl8.4.6 to tcl8.4.11 and
could not get my application to run.  I can get my application to come
up with tcl8.4.6 and the sqlite-3.3.5 with some problems.  After
changing application calls from sqlite to sqlite3 where needed, the
application crashes getting a signum 11 error after calling
sqlite3HashInsert.  I have placed fprintf statements in the
sqlite3HashInsert, so it gets there, it just doesn't return.  It appears
that the arguments are correct in calling the sqlite3HashInsert in
hash.c.  This procedure is called in my application after some parsing
and detecting a semi-colon.  

 

Has anyone experienced problems in their application(s) upgrading to
sqlite-3.3.5 when making a call to sqlite3HashInsert and if so, is there
a solution to this problem?

 

-Bill



Re: [sqlite] SQLite without callback function

2006-05-30 Thread Jay Sprenkle

On 5/30/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:

I think I know the answer to this but I figured it would be better to ask
than to do a major design flaws. :)

What is the most efficient way in SQLite (using the C/C++ interface layer)
to retrieve the result of a query without using the callback function
(setting it to NULL) ?


use the prepare() and bind() functions. It will write the results directly
to your variables. This is much than trying to get callbacks to work with
class methods, escaping sql etc. You can see an example in the source
for the sqlite importer at the site mentioned in my tagline.


--
SqliteImporter, SqliteReplicator: Command line utilities for Sqlite
http://www.reddawn.net/~jsprenkl/Sqlite


[sqlite] SQLite without callback function

2006-05-30 Thread Mario . Hebert
I think I know the answer to this but I figured it would be better to ask 
than to do a major design flaws. :)

What is the most efficient way in SQLite (using the C/C++ interface layer) 
to retrieve the result of a query without using the callback function 
(setting it to NULL) ?

Thanks,

Mario Hebert
Legerity



RE: [sqlite] Purging the mailing list roles. Was: Please RestoreYour Account Access

2006-05-30 Thread Brandon, Nicholas (UK)


>+1 for moderated posting status after  days, -10 for all of the
>other suggestions that will cause me to jump through hoops to stay
subscribed.

I would imagine 95% of the content of this list is done by 20 or so
posters. I'm not one of them.

For similar reasons for staying subscribed, I don't want to jump through
hoops for occasionally posting. If I feel I got something to contribute
I just want to reply and that be the end of it.

So +1 for moderated posting status *only* if its done without additional
effort of the poster (human moderator?).






This email and any attachments are confidential to the intended
recipient and may also be privileged. If you are not the intended
recipient please delete it from your system and notify the sender.
You should not copy it or use it for any purpose nor disclose or
distribute its contents to any other person.



RE: [sqlite] Purging the mailing list roles. Was: Please Restore Your Account Access

2006-05-30 Thread Bob Dankert
I have to agree as well - Quite frequently I am just too busy to read
the list, other times I get a wealth of information from the list.  I
would hate to get unsubscribed because I was too busy to reply to a
message.  Plus, I archive all of my messages in the list so I can search
for previous information.  I may not read some posts right away, but
they do serve a useful purpose for me later down the road.

Being placed on a moderated status would be fine in my opinion, as
described by Eric, for new or infrequent posters.

Bob

-Original Message-
From: Eric Scouten [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, May 30, 2006 10:26 AM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Purging the mailing list roles. Was: Please
Restore Your Account Access

I agree with Jay. I'd hate to have to respond to an e-mail ping every  
so often just to continue reading the list.

On the other hand, I wouldn't mind terribly if I got placed on  
"moderated" status (i.e. had to go through a verification step in  
order to *post* to the list) if I were either (a) new to the list, or  
(b) hadn't posted in a while.

-Eric



On 30 May 2006, at 07:57, Jay Sprenkle wrote:

> On 5/30/06, Eugene Wee <[EMAIL PROTECTED]> wrote:
>> Hi,
>>
>> Basically, what I imagined from DRH's original proposal was that  
>> accounts that
>> have not sent out mails after some period of time would receive an  
>> email
>> informing them that they will be unsubscribed unless they send a  
>> mail to the
>> mailing list, or they reply to this notification email, within  
>> some (short)
>> period of time.
>>
>> I have qualms about asking people to click on a link, since it may  
>> look like a
>> bogus email in which the link will take them elsewhere. You know,  
>> like one of
>> those "your account has expired, click on this link to renew" spam  
>> emails.
>
> I wouldn't want a lot of "I want to stay on the list" mail spamming  
> the list.
>
> You could sign up an autoresponder email account (like paypal) and  
> it would stay
> signed up forever. It would always respond to the query email with a
> reply including
> the original text of the message. You'd need to set it up so they had
> to reply to a
> different email account than the one to send the query mail.



Re: [sqlite] Purging the mailing list roles. Was: Please Restore Your Account Access

2006-05-30 Thread Craig Morrison

Jay Sprenkle wrote:

On 5/30/06, Eric Scouten <[EMAIL PROTECTED]> wrote:

I agree with Jay. I'd hate to have to respond to an e-mail ping every
so often just to continue reading the list.

On the other hand, I wouldn't mind terribly if I got placed on
"moderated" status (i.e. had to go through a verification step in
order to *post* to the list) if I were either (a) new to the list, or
(b) hadn't posted in a while.


As an alternative,  Maybe we should point people who only want to
read the list to a link to an email archive/aggregator and tell them
to search there if they want answers and only to subscribe/resubscribe
if they actively want to post.



Because this penalizes people who want direct delivery.

I don't know about you, but I have spent a lot of time tweaking my 
filters here to get mail delivered to me the way I want it. Trudging 
through someone else's archive is out of the question.


+1 for moderated posting status after  days, -10 for all of the 
other suggestions that will cause me to jump through hoops to stay 
subscribed.


--
Craig Morrison
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
http://pse.2cah.com
  Controlling pseudoephedrine purchases.

http://www.mtsprofessional.com/
  A Win32 email server that works for You.


Re: [sqlite] Purging the mailing list roles. Was: Please Restore Your Account Access

2006-05-30 Thread Jay Sprenkle

On 5/30/06, Eric Scouten <[EMAIL PROTECTED]> wrote:

I agree with Jay. I'd hate to have to respond to an e-mail ping every
so often just to continue reading the list.

On the other hand, I wouldn't mind terribly if I got placed on
"moderated" status (i.e. had to go through a verification step in
order to *post* to the list) if I were either (a) new to the list, or
(b) hadn't posted in a while.


As an alternative,  Maybe we should point people who only want to
read the list to a link to an email archive/aggregator and tell them
to search there if they want answers and only to subscribe/resubscribe
if they actively want to post.


Re: [sqlite] Purging the mailing list roles. Was: Please Restore Your Account Access

2006-05-30 Thread Eric Scouten
I agree with Jay. I'd hate to have to respond to an e-mail ping every  
so often just to continue reading the list.


On the other hand, I wouldn't mind terribly if I got placed on  
"moderated" status (i.e. had to go through a verification step in  
order to *post* to the list) if I were either (a) new to the list, or  
(b) hadn't posted in a while.


-Eric



On 30 May 2006, at 07:57, Jay Sprenkle wrote:


On 5/30/06, Eugene Wee <[EMAIL PROTECTED]> wrote:

Hi,

Basically, what I imagined from DRH's original proposal was that  
accounts that
have not sent out mails after some period of time would receive an  
email
informing them that they will be unsubscribed unless they send a  
mail to the
mailing list, or they reply to this notification email, within  
some (short)

period of time.

I have qualms about asking people to click on a link, since it may  
look like a
bogus email in which the link will take them elsewhere. You know,  
like one of
those "your account has expired, click on this link to renew" spam  
emails.


I wouldn't want a lot of "I want to stay on the list" mail spamming  
the list.


You could sign up an autoresponder email account (like paypal) and  
it would stay

signed up forever. It would always respond to the query email with a
reply including
the original text of the message. You'd need to set it up so they had
to reply to a
different email account than the one to send the query mail.




[sqlite] unsuscribe

2006-05-30 Thread Wood, Lee
Unsubscribe
 


Re: [sqlite] Purging the mailing list roles. Was: Please Restore Your Account Access

2006-05-30 Thread A. Pagaltzis
* Jay Sprenkle <[EMAIL PROTECTED]> [2006-05-30 17:00]:
> You could sign up an autoresponder email account (like paypal)
> and it would stay signed up forever. It would always respond to
> the query email with a reply including the original text of the
> message. You'd need to set it up so they had to reply to a
> different email account than the one to send the query mail.

This suggests a different strategy: alternate between sending
opt-out and opt-in mails. Indiscriminate autoresponders will
unsubscribe themselves when they get an opt-out mail; people who
throw the mail away will silently drop out after failing to
respond to the opt-in mail.

Regards,
-- 
Aristotle Pagaltzis // 


Re: [sqlite] Purging the mailing list roles. Was: Please Restore Your Account Access

2006-05-30 Thread Jay Sprenkle

On 5/30/06, Eugene Wee <[EMAIL PROTECTED]> wrote:

Hi,

Basically, what I imagined from DRH's original proposal was that accounts that
have not sent out mails after some period of time would receive an email
informing them that they will be unsubscribed unless they send a mail to the
mailing list, or they reply to this notification email, within some (short)
period of time.

I have qualms about asking people to click on a link, since it may look like a
bogus email in which the link will take them elsewhere. You know, like one of
those "your account has expired, click on this link to renew" spam emails.


I wouldn't want a lot of "I want to stay on the list" mail spamming the list.

You could sign up an autoresponder email account (like paypal) and it would stay
signed up forever. It would always respond to the query email with a
reply including
the original text of the message. You'd need to set it up so they had
to reply to a
different email account than the one to send the query mail.


RE: [sqlite] Purging the mailing list roles. Was: Please Restore Your Account Access

2006-05-30 Thread Fred Williams
BUT, the spammers ARE posting...

> -Original Message-
> From: Jay Sprenkle [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, May 30, 2006 8:46 AM
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] Purging the mailing list roles. Was: Please
> Restore Your Account Access
>
>
> On 5/29/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> >
> > I wonder if I need to implement some kind of mechanism that requires
> > you to either send a message to the mailing list or else renew your
> > subscription every 3 months.  Does anybody have any experience with
> > other mailing lists that require such measures?
>
> It sounds like Clay figured it out.
> The autoresponder would verify the signup email.
> I'm going to have to rework my own stuff to avoid this too.
>
> On list management, how about this:
>
> * The mailing list periodically selects out all accounts that have not
> posted and disables those accounts.
> * Sends an email to those accounts telling them they're
> disabled due to inactivity and they can reenable by clicking
> on a link.
>
> It drops people who don't read it or that delete mail unread.
> It's minimally intrusive to lurkers.
> There's no overhead for posters.
> It doesn't sound hard to implement.
>
>
> --
> SqliteImporter, SqliteReplicator: Command line utilities for Sqlite
> http://www.reddawn.net/~jsprenkl/Sqlite



RE: [sqlite] Purging the mailing list roles. Was: Please Restore Your Account Access

2006-05-30 Thread Brandon, Nicholas (UK)

>
> I wonder if I need to implement some kind of mechanism that requires
> you to either send a message to the mailing list or else renew your
> subscription every 3 months.  Does anybody have any experience with
> other mailing lists that require such measures?
>

As most people, they are either email replies or a link to a website.

Obviously it depends on your desired goal. If it is keeping automated
scripts away then I would suggest a link to a website to confirm signup.
On that website ask the user to enter a random set of digits displayed
on the page. (That will keep the scripts that open links in confirmation
emails away).

If the goal is a general cleansing, then your suggestion to regularly
"opt-in" sounds fine.

Nick






This email and any attachments are confidential to the intended
recipient and may also be privileged. If you are not the intended
recipient please delete it from your system and notify the sender.
You should not copy it or use it for any purpose nor disclose or
distribute its contents to any other person.



Re: [sqlite] Purging the mailing list roles. Was: Please Restore Your Account Access

2006-05-30 Thread Jay Sprenkle

On 5/29/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:


I wonder if I need to implement some kind of mechanism that requires
you to either send a message to the mailing list or else renew your
subscription every 3 months.  Does anybody have any experience with
other mailing lists that require such measures?


It sounds like Clay figured it out.
The autoresponder would verify the signup email.
I'm going to have to rework my own stuff to avoid this too.

On list management, how about this:

* The mailing list periodically selects out all accounts that have not
posted and disables those accounts.
* Sends an email to those accounts telling them they're
disabled due to inactivity and they can reenable by clicking on a link.

It drops people who don't read it or that delete mail unread.
It's minimally intrusive to lurkers.
There's no overhead for posters.
It doesn't sound hard to implement.


--
SqliteImporter, SqliteReplicator: Command line utilities for Sqlite
http://www.reddawn.net/~jsprenkl/Sqlite


Re: [sqlite] LIMIT and paging records

2006-05-30 Thread Jay Sprenkle

On 5/29/06, Mikey C <[EMAIL PROTECTED]> wrote:


I am using a web front end to display paged results.  I need to tell the
user how many records there are in total, how many pages and which page they
are viewing.

I would like to use the LIMIT keyword to restrict the result using the two
parameters (offset and limit count) so that I do not waste resources loading
up 1000's of records just to discard the ones not on the current page.


If you can eliminate the requirement of giving the user a scroll bar or a count
of results then the need to get a count goes away.

If you can do it you're much better off forcing the user to accept
only the first N
results of any search. Nobody uses more than 10 pages or so of any interactive
result set and most people don't use more than the first couple of
pages. It really
speeds things up and simplifies things when you don't have to deal with very
large results. The users won't look at them anyway. The last time I had to do
this I had to go through a lot of trouble to get it to work acceptably fast.
I wrote special code to return the first page then do all the indexing for the
remaining pages while the user was looking at the first page.

--
SqliteImporter, SqliteReplicator: Command line utilities for Sqlite
http://www.reddawn.net/~jsprenkl/Sqlite


Re: [sqlite] external indexing

2006-05-30 Thread Rusty Conover


On May 30, 2006, at 3:05 AM, Noel Frankinet wrote:


Hello Rusty,
Exactly what I was looking for
I've seen the PRAGMA TEMP_STORE to create a memory table.
Do you think I can join a memory table and a disk based one ?

Anyway, thank a lot
Best wishes



Of course you can do that.

Rusty
--
Rusty Conover
InfoGears Inc.
Web: http://www.infogears.com





Re: [sqlite] SQLITE build for Linux + ARM

2006-05-30 Thread drh
[EMAIL PROTECTED] wrote:
> Hello Paul Bohme,
> 
> Could u please send me across the patch for cross compiling configure 
> script sqlite for ARM + Linux, which u might hav given to ben.
> 
> it would be a great help.
> thanks and awaiting for the reply.
> 

For cross-compiling, your best bet is to make a copy of
Makefile.linux-gcc as just "Makefile" and edit it to suit
your needs.  There isn't much editing that is needed and
everything is commented.
--
D. Richard Hipp   <[EMAIL PROTECTED]>



Re: [sqlite] external indexing

2006-05-30 Thread Noel Frankinet

Rusty Conover wrote:



Using a temporary table seems to be the best way when you have lots  
of keys.  Of course there is a tradeoff point, such as for 1 or 2  
rows a temporary table is overkill.  Also it depends on if you're  
temporary table is being stored in memory or on the disk, check the  
relevant PRAGMA documentation to specify how you want them stored.


CREATE TEMP TABLE search_keys(oid INTEGER NOT NULL PRIMARY KEY);

Next, insert all of the records you're searching for into search_keys  
table.


You might want to do an "ANALYZE" here on the temporary table, so the  
planner can pick the most efficient way to do the upcoming join  
depending on the number of rows you're searching for, and the number  
of rows you're searching in.


Do the actual select:

SELECT ... from search_keys, target where search_keys.oid = bar.oid

I believe the ordering of the tables in the from clause may be  
important as the planner may use it in determining which table to  
process first, but if there are statistics about all of the tables it  
may reorder them.  drh, would know actual behavior for sure.


Finally don't forget to:

DROP TABLE search_keys

Cheers,

Rusty
--
Rusty Conover
InfoGears Inc.
Web: http://www.infogears.com



Hello Rusty,
Exactly what I was looking for
I've seen the PRAGMA TEMP_STORE to create a memory table.
Do you think I can join a memory table and a disk based one ?

Anyway, thank a lot
Best wishes


--
Noël Frankinet
Gistek Software SA
http://www.gistek.net



Re: [sqlite] external indexing

2006-05-30 Thread Rusty Conover


On May 30, 2006, at 1:36 AM, Noel Frankinet wrote:


Hello All,

since nobody has answered my last question, I'll try to rephrase it :
How do you select record you have the keys (and I mean a lot of keys)
I know
SELECT .. WHERE rowid=
SELECT .. WHERE rowid IN (something like that)
SELECT ... WHARE rowid BETWEEN ...

Is there another way, does a temporary table helps ?


Using a temporary table seems to be the best way when you have lots  
of keys.  Of course there is a tradeoff point, such as for 1 or 2  
rows a temporary table is overkill.  Also it depends on if you're  
temporary table is being stored in memory or on the disk, check the  
relevant PRAGMA documentation to specify how you want them stored.


CREATE TEMP TABLE search_keys(oid INTEGER NOT NULL PRIMARY KEY);

Next, insert all of the records you're searching for into search_keys  
table.


You might want to do an "ANALYZE" here on the temporary table, so the  
planner can pick the most efficient way to do the upcoming join  
depending on the number of rows you're searching for, and the number  
of rows you're searching in.


Do the actual select:

SELECT ... from search_keys, target where search_keys.oid = bar.oid

I believe the ordering of the tables in the from clause may be  
important as the planner may use it in determining which table to  
process first, but if there are statistics about all of the tables it  
may reorder them.  drh, would know actual behavior for sure.


Finally don't forget to:

DROP TABLE search_keys

Cheers,

Rusty
--
Rusty Conover
InfoGears Inc.
Web: http://www.infogears.com





[sqlite] external indexing

2006-05-30 Thread Noel Frankinet

Hello All,

since nobody has answered my last question, I'll try to rephrase it :
How do you select record you have the keys (and I mean a lot of keys)
I know
SELECT .. WHERE rowid=
SELECT .. WHERE rowid IN (something like that)
SELECT ... WHARE rowid BETWEEN ...

Is there another way, does a temporary table helps ?

Thank you

--
Noël Frankinet
Gistek Software SA
http://www.gistek.net



[sqlite] Performance degradation when using sqlite 3.3.5 program against sqlite 3.2.1 db-files

2006-05-30 Thread sandra
We have recompiled several applications with new sqlite 3.3.5 library.

We have observed that one of these application, which access intensively
(read-only) a large number (around 180) of old sqlite 3.2.1 db-files (4
million records, 2GB, each) runs now much slower.
These files are updated sporadically by another application (also
recompiled with sqlite 3.3.5).

Is there any performance degradation for a new, 3.3.5, application
accessing an old, 3.2.1, db-file versus an old application, 3.2.1,
accessing old, 3.2.1, db-files?

Thanks,
Sandra Toloba



[sqlite] SQLITE build for Linux + ARM

2006-05-30 Thread Shishir . Rawat
Hello Paul Bohme,

Could u please send me across the patch for cross compiling configure 
script sqlite for ARM + Linux, which u might hav given to ben.

it would be a great help.
thanks and awaiting for the reply.

cheers,
shishir
[EMAIL PROTECTED]