[sqlite] what is the tool name which worked as db2's performance monitor

2011-03-20 Thread zeal
Hi, i just want to find a tool in oracle which could format the log and tell me who eat much cpu time. as i know, it name is performance monitor, but i do not know which could do this job in oracle. thanks. daisy ___ sqlite-users mailing list sqlit

Re: [sqlite] SQLite.so dynamic library-linux

2011-03-20 Thread thilo
On 3/20/2011 3:32 PM, Simon Slavin wrote: > > On 20 Mar 2011, at 1:55pm, thilo wrote: > >> I know the issue with Vxworks. it's hard to buy all those >> strange platforms, but linux should be a must to test before >> release! > > Linux is a test before release. But how many distributions and > versi

Re: [sqlite] Help me understand the sqlite query optimizer

2011-03-20 Thread Simon Slavin
On 21 Mar 2011, at 3:33am, Guilherme Batista wrote: > I'll implement some changes in the sqlite query optimization for study > purpose... before I start studying the code please help me understand the > basic idea... > > 1) The basic idea of optimization is to optmize and then execute. Where in

[sqlite] Newbie question

2011-03-20 Thread Kai Peters
Hi all, given a table with two columns (SaleDate, SaleVolume) is it possible in one query to obtain the following three column result set: SalesCurrentYear, SalesLastYEar, SalesAllyears ? Thanks as always for any help, Kai ___ sqlite-users mailing

[sqlite] Help me understand the sqlite query optimizer

2011-03-20 Thread Guilherme Batista
Hi!! I'll implement some changes in the sqlite query optimization for study purpose... before I start studying the code please help me understand the basic idea... 1) The basic idea of optimization is to optmize and then execute. Where in the code the plan is built and where it is executed? 2) I

Re: [sqlite] sqlite-users Digest, Vol 39, Issue 20

2011-03-20 Thread Udon Shaun
From: "sqlite-users-requ...@sqlite.org" To: sqlite-users@sqlite.org Sent: Sun, March 20, 2011 12:00:01 PM Subject: sqlite-users Digest, Vol 39, Issue 20 >I can't help with the .so, but you could load up a virtual machine with one >of the free VM engines (VMWa

[sqlite] ANN: "AnyDAC for Delphi" Spring 2011 v 4.0.7 released

2011-03-20 Thread Dmitry Arefiev
Dear Sir or Madam, DA-SOFT Technologies announces the immediate availability of "AnyDAC for Delphi" Spring 2011 release v 4.0.7.1719. AnyDAC for Delphi = AnyDAC is an unique set of Universal Data Access Components for developing applications on Delphi, C++Builder and Free Pascal.

Re: [sqlite] SQLite.so dynamic library-linux

2011-03-20 Thread Simon Slavin
On 20 Mar 2011, at 1:55pm, thilo wrote: > I know the issue with Vxworks. it's hard to buy all those strange > platforms, but linux should be a must to test before release! Linux is a test before release. But how many distributions and versions do you expect testing to be done for ? And how m

Re: [sqlite] SQLite.so dynamic library-linux

2011-03-20 Thread thilo
On 3/18/2011 3:54 PM, Udon Shaun wrote: > Hi Peeps. > I've noticed that the SQLite site no longer posts the linux x32 so library > (only > the windows ones) which is a bit of a pain because I compile only in windows. > > Does anyone have a linux x32 build (sqlite 3.7.5) with the following > com

Re: [sqlite] SQLite.so dynamic library-linux

2011-03-20 Thread Enrico Thierbach
Hi Udon, > > But to answer your question. more fully.LabVIEW is cross platform (MAC, > Win,VXWorks & Linux). Therefore the API I provide can (and does) work under > all > those systems (and ,many users have been using it in those OSs for some time) > - > you just need the SQLite library compi