Try connecting to this database using the SQLite command line browser and
then check if the table 'tb1' exists. Most probably it dosen't.
You can check which all tables have been created using the query -
"select * from sqlite_master"
Regards,
Ritesh
> I've had to do a complete backtrack today.
Hi,
I've read a lot of mails on this group regarding use of Sqlite in-memory
mode, for better performance.
Currently we're using file based Sqlite DB and are facing lot of
performance issues since the DB file is accessed a zillion times in a
single program run.
I've decided to try out the in-mem
eletion.
Can anyone give me some more ideas to work with. Does this performance
problem happen with the other DB's available as well?
--
Regards,
Ritesh Kapoor
"living in interesting times..."
ne on this mailing list would help you. However my experience with
these handlers was that they made a mess of the code and later on the
code was incomprehensible to someone looking at the code for the first
time.
--
Regards,
Ritesh Kapoor
"living in interesting times..."
--- Begin Mes
remove all locking code in
sqlite. I googled and did find some information related to NFS-locking
on different mailing lists but all of this information wasn't
connected. This seems to be a problem known for a long time now - Why
hasn't it been fixed?
--
Regards,
Ritesh Kapoor
&q
o
keep a counter in your code.
This worked for me since my case is similar. If anyone feels that this
approach has any flaws then do criticise.
--
Regards,
Ritesh Kapoor
"I can do it right, fast or cheap. Pick any two."
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
Hi,
I am looking for some documentation alongwith examples on the Aggregate
Functions concept in SQLite. Please let me know of some link where this
concept is explained and with examples on the functions -
sqlite3_create_function()
sqlite3_aggregate_context()
Thanks & Regards,
Ritesh
Hi,
I am debugging a program which has a FileTable field called FileName
declared as-
"FileName varchar(1024) primary key"
It stores filenames including their paths e.g. - "myDir1/testfile.txt"
If I were to search in this FileTable in the column FileName for a
string "testfile.txt" would it re
FileName like "%/testfile.txt"
>
> then you would get all files named "testfile.txt" regardless of their
> path. sqlite will search for strings ending in "/testfile.txt".
>
> Martin
>
> Ritesh Kapoor schrieb:
>
> >Hi,
> >
> >I am
thanks for your help
I got my work done
ritesh
On Mon, 2005-12-05 at 17:11, Rob Lohman wrote:
> It seems we are both right :)
>
> sqlite> create table test (filename varchar(1000) primary key);
> sqlite> insert into test (filename) values ('test');
> sqlite> select * from test where filename='t
2. Employee_Offical_Info
3. Corporate_Info
Is there a way to retrieve the names of the tables assuming that I do
have a connection open with the DB.
Thanks,
Ritesh Kapoor
Senior Software Engineer
Atrenta Pvt. Ltd.
e on all of its columns?
3. Please note that the columns on which comparisions are done are of
varchar type also so do indexes work on them as well?
4. Any other suggestions which the experienced folks would have come
across.
Thanks and Regards,
Ritesh Kapoor
Atrenta Pvt. Ltd.
thnx
my queries are running in 1/3rd the time now!!
ritesh
On Mon, 2006-01-02 at 22:22, Dennis Cote wrote:
> Ritesh Kapoor wrote:
>
> >Hi,
> >
> >I need to optimize/speed up my 'select' queries. The query creates
> >about 3 to 6 left joins from 7 differ
my machine.
Can anyone suggest what the problem is with sqlite when running apps on
different machines. I couldn't find much related to this on the sqlite
website.
Thanks & Regards,
Ritesh Kapoor
EMAIL PROTECTED] wrote:
> Ritesh Kapoor <[EMAIL PROTECTED]> wrote:
> >
> > Can anyone suggest what the problem is with sqlite when running apps on
> > different machines.
>
> This happens sometimes when NFS us misconfigured so that it
> does not support fcntl() fil
s there a way to find out which process is doing this
through the entries in /proc directory?
Thanks,
Ritesh
On Mon, 2006-01-30 at 19:31, [EMAIL PROTECTED] wrote:
> Ritesh Kapoor <[EMAIL PROTECTED]> wrote:
> > Yes.
> > My machine has NFS and the machines I log onto also have NFS.
Please ommit line #18 from the sequence of statements
and then reply.
Thanks
Ritesh
On Tue, 2006-01-31 at 16:42, Ritesh Kapoor wrote:
> Regarding the configuration of NFS -
> I have two machines with NFS on them.
> - if i run the app on machine 1 it works properly
> - now when i ru
f commands and will get back to
you.
Thanks for you help. If you have any other suggestions then please do
let me know
Thanks
Ritesh
On Tue, 2006-01-31 at 18:02, Christian Smith wrote:
> On Tue, 31 Jan 2006, Ritesh Kapoor wrote:
>
> >Regarding the configuration of NFS -
> >I h
:
> On Tue, 31 Jan 2006, Ritesh Kapoor wrote:
>
> >Regarding the configuration of NFS -
> >I have two machines with NFS on them.
> >- if i run the app on machine 1 it works properly
> >- now when i run the app on machine 2 it works properly
> >
> >But if I
06-01-30 at 19:31, [EMAIL PROTECTED] wrote:
> Ritesh Kapoor <[EMAIL PROTECTED]> wrote:
> > Yes.
> > My machine has NFS and the machines I log onto also have NFS. But if
> > this is the problem then why dosen't it appear on my machine when I run
> > the app.
>
>
In case the designer knows that the DB file will be accessed by a single
program-thread throught the run - then there should be some sort of flag
indicating that SQLITE should execute minimum locking-related code.
We were facing problems with flock over NFS mounted file systems. Since
we din't ne
21 matches
Mail list logo
