.)
Regards,
Prakash Reddy Bande
Altair Engg. Inc,
Troy, MI
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
Thanks,
I will try both (ASCII and BLOB) approaches and see speed vs. storage
trade-offs. Any more ideas are welcome.
Regards,
Prakash Reddy Bande
Altair Engg. Inc,
Troy, MI
-Original Message-
From: John Stanton [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 29, 2007 11:26 AM
To
sure it's a large number and I hope my database will not consume
all of it). Moreover, when the database no longer uses a uuid, it can be
removed from this table too, which might mean a considerable work for
application developer :-).
Regards,
Prakash Reddy Bande
Altair Engg. Inc,
Tro
ng wrong?
Regards,
Prakash Reddy Bande
Altair Engg. Inc,
Troy, MI
OK,
I figured it out X should be followed by only hex characters 0-9, a-f.
Regards,
Prakash Reddy Bande
Altair Engg. Inc,
Troy, MI
-Original Message-
From: Prakash Reddy Bande [mailto:[EMAIL PROTECTED]
Sent: Friday, August 31, 2007 4:00 PM
To: sqlite-users@sqlite.org
Subject: [sqlite
aggregate. But the query did give some results.
How does SQLite choose which row to return from a group?
Regards,
Prakash Reddy Bande
Altair Engg. Inc,
Troy, MI
that 3.5.1
will be as stable as 3.4.0.
The reason I am moving over is that the sources for fts are based 3.5.1.
How can I get the sources of fts based on 3.4.0 if I have to use 3.4.0?
Regards,
Prakash Reddy Bande
Altair Engg. Inc,
Troy, MI
any in memory cached data in my processes.
How do I go about achieving this?
Regards,
Prakash Reddy Bande
Altair Engg. Inc,
Troy, MI
from updatelog
Doing this, I can have every connection have its own updatelog table
Prakash Reddy Bande
Altair Engg. Inc,
Troy, MI
Me too, all attempts to unsubscribe have failed. I have put a filter, but still
my .pst is becoming big.
From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] On
Behalf Of Pece Cvetkoski [pcvetko...@yahoo.com]
Sent: Saturday, May 22, 2010
Hi,
I have stumbled upon the issue as described in http://sqlite.org/faq.html#q5
(But use caution: this locking mechanism might not work correctly if the
database file is kept on an NFS filesystem.)
The question is, do we have a workaround. Our application has to store data in
user home direct
SQLite Database
Subject: Re: [sqlite] Locking issue on NFS filesystem
On 14 Jun 2010, at 3:16am, Prakash Reddy Bande wrote:
> I have stumbled upon the issue as described in http://sqlite.org/faq.html#q5
> (But use caution: this locking mechanism might not work correctly if the
> databas
-
Hash: SHA1
On 06/14/2010 02:56 AM, Prakash Reddy Bande wrote:
> Our application is a simple desktop application with a simple install and run
> setup. It is not possible to tell users to apply workaround of sharing the
> drive via SMB etc.
BTW SMB won't be much better tha
Hello,
I want to use sqlite as a db on a shared network drive (windows) (user would
map the network drive to say T:). I read the documentation section "File
Locking And Concurrency In SQLite Version 3"
(http://www.sqlite.org/lockingv3.html)
Where following is clearly mentioned:
"SQLite uses
Database
Subject: Re: [sqlite] File Locking And Concurrency In SQLite Version 3
On 12 Nov 2010, at 5:58pm, Prakash Reddy Bande wrote:
> My question: Is it possible to verify if the network drive on which the DB is
> place can be used?
Great question. Unfortunately LockFile() generally doe
Hi,
I have set a busy handler.
int ret = sqlite3_open(dbname.c_str(), &m_ppDb);
sqlite3_busy_handler(m_ppDb, &hwLMsqlite3BusyHandler, 0);
However it is not getting called. Here is what I am doing:
1. Using the sqlite3.exe run the following commands
begin transaction;
update users set name="hello
;
>
> I get SQLITE_BUSY and hwLMsqlite3BusyHandler is not getting called.
What query do you use?
Pavel
On Fri, Nov 12, 2010 at 4:51 PM, Prakash Reddy Bande
wrote:
> Hi,
>
> I have set a busy handler.
>
> int ret = sqlite3_open(dbname.c_str(), &m_ppDb);
> sqlite3_busy_
-0500, Prakash Reddy Bande scratched on the
wall:
> Hi,
>
> I have set a busy handler.
>
> int ret = sqlite3_open(dbname.c_str(), &m_ppDb);
> sqlite3_busy_handler(m_ppDb, &hwLMsqlite3BusyHandler, 0);
>
> However it is not getting called.
As the docs for sqlite3_b
Hi,
I have a database placed on a shared drive.
Two processes (from different hosts) do a bunch of select commands.
I have a busy handler that sleeps of 1 second in each attempt and bails out
after 10 attempts.
The observation is that, if only one process is running (on any host) the
results a
Hi,
I have observed that when multiple processes from "different" hosts are
concurrently doing the queries, the performance of sqlite degrades considerably.
Queries are read only hence I believe that there should not be any locking
issues (no busy handler called).
I will dig a little more in my
Hi,
As per documentation opening a database with SQLITE_OPEN_NOMUTEX flag opens it
in multi-threaded mode.
http://www.sqlite.org/threadsafe.html says In this mode, SQLite can be safely
used by multiple threads provided that no single database connection is used
simultaneously in two or more thr
Hi,
I wanted to get an understanding of SQLite Encryption Extension. I am currently
using sqlite-3.7.2, and if I want to use SEE, would it be equally compatible.
Well, the http://www.hwaci.com/sw/sqlite/see.html page does not give much
information, i.e. do still build sqlite from public and inj
Hi,
We were looking at the ways we can optimize our application. Our app does a
simple sqlite3_exec and sends the callback as below. The data is just a
map >
int sqlite3TableCallback(void* data, int ncols, char** values, char** headers)
{
map >& table = *(( map >*) data);
23 matches
Mail list logo