[sqlite] (no subject)

[vallur raghava reddy]

Hi,
I have few queries regarding the SQLite. I have listed them below please go
through them and give your answers. Thanks
Say if I am working on a DB with 3 tables with 100 records each and each
records with some 5 fields of data.Each field is varchar(20)

  1. What will be the Stack Size?
  2. What will be the Heap Size?
  3. What is the max no. of file pointers that will be used at a point of
  time?
  4. What is the max no. of Mutexes that will be used at a point of time?
  5. Is there a tool to calculate these?

Please bare my ignorance if any and answer these questions.

Thanks Again,

Raghava Reddy
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] 100% CPU utilization sqlite running in VMWare

[IQuant]

Yes:  Inserts wrapped in transactions 10,000 at a shot.

Tried pragma synchronous=OFF

And 3 different threadsafe compilations for sqlite:
# define SQLITE_THREADSAFE 0 /* IMP: R-07272-22309 */
# define SQLITE_THREADSAFE 1 /* IMP: R-07272-22309 */
# define SQLITE_THREADSAFE 2 /* IMP: R-07272-22309 */

All other settings are default.

all 6 versions peg the cpu when i run concurrent instances => # of cores.

Bare Metal wrote to local disk.  Will test writing to same share next.
VM's write to NAS (Windows server 2008 mapped network drive).

<<<  Response to: >>>
Have you run your bare metal test using the same share?

And have you tried "pragma synchronous=OFF" ??

And I assume you are using transactions?

Have you profiled your app to see where it's spinning?  Probably
trying to get the lock on the share.

What flags did you use to comiple the sqlite library?  In particular
for threadsafe?

Michael D. Black
Senior Scientist
Advanced Analytics Directorate
Advanced GEOINT Solutions Operating Unit
Northrop Grumman Information Systems
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] how to?

[Kevin Benson]

On Tue, Jun 5, 2012 at 12:43 PM, Jonas Malaco Filho <
jonasmalacofi...@gmail.com> wrote:

> I think that session info is stored in sessionrestore.js, in your Firefox
> profile data folder. There is also a sessionrestore.bak, that may help you.
> You can check if you have other (older) versions of these files thanks to
> shadowing (or any other recovery methods).
>
> *Jonas Malaco Filho*
>
http://support.mozilla.org/en-US/questions/927930#answer-335629
--
   --
  --
 --Ô¿Ô--
K e V i N

>
> 2012/6/5 Simon Slavin 
>
> >
> > On 5 Jun 2012, at 12:26pm, baboushka jane 
> wrote:
> >
> > > i hope i have found the right place. i would like some help with my
> > sqlite files.
> > > a week or so back i was clearing my recent Firefox history when my
> > browser froze and so i used Activity Monitor to force close Firefox.
> > meanwhile, i was reading an e-mail and clicked on a link which opened up
> a
> > new session.. meaning, i could not retrieve my last session - i.e. the
> > countless tabs that i had open when i force closed..
> > > after a little googling, i think i gather that this last session is
> > somewhere in a sqlite file on my HD.
> > > i had some really valuable reading lined up that i unfortunately didn't
> > bookmark in time.. thank you so much in advance!
> >
> > Sorry, but you need an expert in FireFox, not one in SQLite.  Try asking
> > on one of the FireFox support lists.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] how to?

[Jonas Malaco Filho]

I think that session info is stored in sessionrestore.js, in your Firefox
profile data folder. There is also a sessionrestore.bak, that may help you.
You can check if you have other (older) versions of these files thanks to
shadowing (or any other recovery methods).

*Jonas Malaco Filho*



2012/6/5 Simon Slavin 

>
> On 5 Jun 2012, at 12:26pm, baboushka jane  wrote:
>
> > i hope i have found the right place. i would like some help with my
> sqlite files.
> > a week or so back i was clearing my recent Firefox history when my
> browser froze and so i used Activity Monitor to force close Firefox.
> meanwhile, i was reading an e-mail and clicked on a link which opened up a
> new session.. meaning, i could not retrieve my last session - i.e. the
> countless tabs that i had open when i force closed..
> > after a little googling, i think i gather that this last session is
> somewhere in a sqlite file on my HD.
> > i had some really valuable reading lined up that i unfortunately didn't
> bookmark in time.. thank you so much in advance!
>
> Sorry, but you need an expert in FireFox, not one in SQLite.  Try asking
> on one of the FireFox support lists.
>
> Simon.
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Select into outfile C API

[patrick]

Is their a syntax similar to mysql's 'SELECT INTO OUTFILE' in the C API?
I see the sqlite3 binary has an interactive .output parameter.  Anything 
similar in the C API?

TIA
Pat...
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] how to?

[Simon Slavin]

On 5 Jun 2012, at 12:26pm, baboushka jane  wrote:

> i hope i have found the right place. i would like some help with my sqlite 
> files.
> a week or so back i was clearing my recent Firefox history when my browser 
> froze and so i used Activity Monitor to force close Firefox. meanwhile, i was 
> reading an e-mail and clicked on a link which opened up a new session.. 
> meaning, i could not retrieve my last session - i.e. the countless tabs that 
> i had open when i force closed..
> after a little googling, i think i gather that this last session is somewhere 
> in a sqlite file on my HD.
> i had some really valuable reading lined up that i unfortunately didn't 
> bookmark in time.. thank you so much in advance!

Sorry, but you need an expert in FireFox, not one in SQLite.  Try asking on one 
of the FireFox support lists.

Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] 100% CPU utilization sqlite running in VMWare

[Black, Michael (IS)]

Have you run your bare metal test using the same share?

And have you tried "pragma synchronous=OFF" ??

And I assume you are using transactions?

Have you profiled your app to see where it's spinning?  Probably trying to get 
the lock on the share.

What flags did you use to comiple the sqlite library?  In particular for 
threadsafe?

Michael D. Black
Senior Scientist
Advanced Analytics Directorate
Advanced GEOINT Solutions Operating Unit
Northrop Grumman Information Systems



From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on 
behalf of IQuant [sql...@iquant.co.cc]
Sent: Monday, June 04, 2012 11:48 PM
To: sqlite-users@sqlite.org
Subject: EXT :[sqlite] 100% CPU utilization sqlite running in VMWare


Have a market data extractor running tick tapes and saving data to sqlite db.
All coded in C++ and previously ran fine and fast on bare metal.

Processes tick tapes from NAS and saved to local sqlite db's on c drive.

We moved program onto VMWare VM's... same nas tick tapes.  Writing
db's to a share.

On a 4 core vm we can run 3 extractors concurrently at 25 - 75% CPU
utilization.  The 4th pegs the CPU at 100%

Same on an 8 core VM ... seems we can run Cores - 1 without pegging the CPU.

The memory footprint for the program is a tiny 9mb...  On bare metal
we can run 20 extractors concurrently.   Looking for suggestions on
how to optimize for VMware.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] how to?

[baboushka jane]

i hope i have found the right place. i would like some help with my sqlite 
files.
a week or so back i was clearing my recent Firefox history when my browser 
froze and so i used Activity Monitor to force close Firefox. meanwhile, i was 
reading an e-mail and clicked on a link which opened up a new session.. 
meaning, i could not retrieve my last session - i.e. the countless tabs that i 
had open when i force closed..
after a little googling, i think i gather that this last session is somewhere 
in a sqlite file on my HD.
i had some really valuable reading lined up that i unfortunately didn't 
bookmark in time.. thank you so much in advance!
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] encrypt/decrypt sqlite3 database file or content

[Richard Hipp]

On Tue, Jun 5, 2012 at 2:49 AM, Durga D  wrote:

> Hi All,
>
>
>I am developing sqlite3 based application. I want to create/maintain
> sqlite3 database in encrypted. Others should not have rights to open this
> database without key. Is there any sqlite3 api's to do this?
>

http://www.hwaci.com/sw/sqlite/see.html


>
>Thanks in advance.
>
> Regards,
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] encrypt/decrypt sqlite3 database file or content

[Durga D]

Hi All,


I am developing sqlite3 based application. I want to create/maintain
sqlite3 database in encrypted. Others should not have rights to open this
database without key. Is there any sqlite3 api's to do this?

Thanks in advance.

Regards,
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users