I am yet to get answers for the following questions.
> What happens if I set the cache_size to 0? Will I be able to do any of
> update/delete/insert/select operations?
>
> When I set the cache_size to 0, is there any freeing up of memory by
> sqlite?
Regards,
Phani
Thanks to all those who assisted me with this issue. After manipulating
the 'new parameters' table in another environment I was able to ensure
that I had the columns required to allow select statements the did NOT
include the table to be updated... I also took some hints from:
> - Original Message
> From: Joe Wilson <[EMAIL PROTECTED]>
> To: sqlite-users@sqlite.org
> Sent: Monday, June 11, 2007 8:36:32 PM
> Subject: Re: [sqlite] Database replication question
>
>
> Large bulk inserts with more than one index (implicit or explicit)
> is not SQLite's strong
Large bulk inserts with more than one index (implicit or explicit)
is not SQLite's strong suit.
If you search the mailing list archives you'll find a few suggestions:
- "BEGIN EXCLUSIVE" (or is it "BEGIN IMMEDIATE"?) on the
database file and then copy the file over - fastest way
or
-
I've opened a new ticket 2409.
http://www.sqlite.org/cvstrac/tktview?tn=2409,38
Also I found that it happenes from SQLite 3.3.9.
--
tamagawa ryuji
> Hi, Richard. Thank you for your very quick response.
>
>>> 1) Run a program SQLiteCrush.exe.
>>>This program updates 'test.db' repeatedly.
Hi all
I am trying to put in place a simple replication process to copy a database
from one machine to an other.
The table I have is something like
CREATE TABLE sn2uid(sn VARCHAR(100) NOT NULL, uid INTEGER NOT NULL, PRIMARY KEY
(sn));
CREATE INDEX uidindex on sn2uid ( uid )
Where the (sn,uid)
Ellis Robin (Bundaberg)
<[EMAIL PROTECTED]> wrote:
Thanks Igor, the records in the Parameter table are required to ensure
that the values returned from NewParams are matched to the appropriate
records.
They are matched to the record you are updating. SQLite walks all
records in Parameter
After some more experimentation I have determined that the rowCount()
method in the PDOStatement object just doesn't work. Using your ultra
simple SQL test I get this:
PDOStatement Object
(
[queryString] => select 123 as abc;
)
rows = 0
Joe Wilson wrote:
$sql = "SELECT count(*)
You can keep the prepared SQl and re-use it by using sqlite3_reset.
Rob Richardson wrote:
Igor,
Thank you very much for your reply. My naïve impression was that sqlite3_prepare/step/finalize are used for SELECT statements, where there would be a result set one would want to step through, and
Thanks Igor, the records in the Parameter table are required to ensure
that the values returned from NewParams are matched to the appropriate
records. By removing the referenecs to Parameter in the FROm statement I
achieve 0 updates.
Thanks to all, I'll dump to another DB and do the work there.
"weiyang wang" <[EMAIL PROTECTED]> wrote:
> hi,
>
> i am trying to get a smaller sqlite lib by adding sqlite_omit_xx defines.
> but it failed at the compiler time.
>
> steps:
> 1, in 'Makefile.in', omit macro is added:
>
> TCC += -DSQLITE_OMIT_ALTERTABLE=1
>
> 2, run '(top)/configure' and
> TabA.ID1
> TabA.ID2
> TabA.field1
>
> TabB.ID1
> TabB.ID2
> TabB.field2
>
> TabC.ID1
> TabC.field3
>
> ViewBC:
> SELECT * FROM TabB INNER JOIN TabC On TabB.ID1 = TabC.ID1
>
> This is slow:
> SELECT field1, field2, field3 from TabA LEFT OUTER JOIN ViewBC ON TabA.ID1 =
> ViewBC.ID1 AND TabA.ID2
hi,
i am trying to get a smaller sqlite lib by adding sqlite_omit_xx defines.
but it failed at the compiler time.
steps:
1, in 'Makefile.in', omit macro is added:
TCC += -DSQLITE_OMIT_ALTERTABLE=1
2, run '(top)/configure' and 'make' in cygwin,
3, i got the fowllowing error:
Hi, Richard. Thank you for your very quick response.
>> 1) Run a program SQLiteCrush.exe.
>>This program updates 'test.db' repeatedly. Insert data
>>to work table, copy them into items table, then delete
>>records from work.
>Does SQLiteCrush.exe continue running in the background
=?iso-2022-jp?B?GyRCNkxAbhsoQiAbJEJONTtKIWMbKEJlLRskQiU9JWolZSE8JTcbKEI=?=
=?iso-2022-jp?B?GyRCJWclczt2NkhJdDMrSC9JdDMrSC8yXSFkGyhC?= <[EMAIL
PROTECTED]> wrote:
>
> I encountered a problem with SQLite3.3.17 on Windows XP. Under certain
> situation,
> database file got seriously
Hello Lists,
I encountered a problem with SQLite3.3.17 on Windows XP. Under certain
situation,
database file got seriously corrupted.
SQLite version: 3.3.17 Windows Binary
Platform:Windows XP SP2(Japanese)
Code wrtten in: Visual C++ 6.0
Here are the procedures to reproduce the problem:
1)
Hello, Ghislain,
Regarding: any tool or instrument which could help me to analyze the
performances of SQLite
You may want to write again and be a bit more specific.
What operating system are you using? What wrapper, if any?
Do you need to analyze your SQL and try to make it run more
"Rob Richardson" <[EMAIL PROTECTED]> wrote:
>
> So, let's say we want to delete a record using "DELETE FROM my_table =
> WHERE my_key = my_unwanted_value". I would just pass that string into =
> sqlite3_prepare16(), then call sqlite3_step() to actually do the =
> deletion (and return
This is a question for your OS vendor.
--- "Rachmel, Nir (Nir)" <[EMAIL PROTECTED]> wrote:
> I have run into a problem - using the same environment variables as I
> did in the old version ( I am upgrading from 3.2.8 to the newest version
> of 3.3.17), I am unable to compile succesfully.
> Here is
Igor,
Thank you very much for your reply. My naïve impression was that
sqlite3_prepare/step/finalize are used for SELECT statements, where there would
be a result set one would want to step through, and that one would use
sqlite3_exec() for statements where no result set is expected, such as
Hello,
my name is Ghislain ,i find any tool or instrument which could help me
to analyze the performances of SQLite.Please all the suggestions being
able to help me would also to me.
Thank you
correct my former message, the smallest is 10, (10 pages in ram)
On 6/11/07, B V, Phanisekhar <[EMAIL PROTECTED]> wrote:
What happens if I set the cache_size to 0? Will I be able to do any of
update/delete/insert/select operations?
When I set the cache_size to 0, is there any freeing up of
the smallest cache_size is 512k, i guess.
On 6/11/07, B V, Phanisekhar <[EMAIL PROTECTED]> wrote:
What happens if I set the cache_size to 0? Will I be able to do any of
update/delete/insert/select operations?
When I set the cache_size to 0, is there any freeing up of memory by
sqlite?
What happens if I set the cache_size to 0? Will I be able to do any of
update/delete/insert/select operations?
When I set the cache_size to 0, is there any freeing up of memory by
sqlite?
Regards,
Phani
by checking the codes, i could see temp_store_directory is used to overide
the platform-specific default temp directory in run time.
That is, if temp_store_directory is 0 (the default value of
temp_store_directory), then OS layer (os_win.x and os_unix.x) will provide
the OS default temp
Hi,
Thanks for the response - your assumption seems reasonable - I am no
able to use a different malloc library on my system, but I do want to
try and upgrade my sqlite, since I have noticed I am using quite an old
version, and who knows..
I have run into a problem - using the same environment
26 matches
Mail list logo