On 12/11/2015 08:22 PM, ajm at zator.com wrote:
>> Mensaje original
>> De: Dan Kennedy
>> Para: sqlite-users at mailinglists.sqlite.org
>> Fecha: Fri, 11 Dec 2015 15:28:33 +0700
>> Asunto: Re: [sqlite] Problem when upgrading from FTS3/4 to
>> FTS5modules(revisited)
>>
>>> 1a.-
Thanks for your help! What you have said makes sense.
I will try it! As soon as possible, I will tell you the testing result on
Monday..
At 2015-12-11 20:16:24, "Keith Medcalf" wrote:
>
>Actually, you need to pull the power plug after you shut it down for more than
>30 seconds,
Hello
After migration from Windows Server 2003 to Windows Server 2012R2 the following
error occurs in the C# library SQLite (version 1.0.98.0): (NuGet Package)
"That assembly does not allow partially trusted"
The server is shared and there is no possibility to change system settings. The
1.Reboot computer
2.Shut down computer ,and then start computer
the two method above , can not also solve the cache perfectly.
the testing computer is dell.
At 2015-12-11 16:29:09, "???" <2004wqg2008 at 163.com> wrote:
>1.Reboot computer
> 2.Shut down computer ,and then start computer
>
1.Reboot computer
2.Shut down computer ,and then start computer
the two method above , can also solve the cache perfectly.
the testing computer is dell.
At 2015-12-11 16:22:44, "Clemens Ladisch" wrote: >Hick
Gunter wrote: >> 2) run each query in a new process (so each one will need to
read
Hi all
I am having a problem accumulating decimal values.
I am actually using Python, but I can reproduce it in the sqlite3 interactive
terminal.
SQLite version 3.8.6 2014-08-15 11:46:33
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen
Because of I want to test some funtions of the SQLite.
According to Clemens said, the testing result may be influenced by cache.
How could avoid the influence of cache? Is there funtion can eliminate the
influence?
best regards.
WQG
At 2015-12-11 15:40:56,
> 1a.- Delete the previous table.
> DROP TABLE IF EXIST ftsm
>
> This scheme work ok with the FST3/4 modules, but compiling with FTS5 gives an
> erroro in 1a: "database disk image is malformed".
>
> Note that in previous attemps I believed that the problem was into try to
> delete a ftsm table
HI,Hick Gunter,
Thanks for you reply.
I find a strange problem.
For example, tableA contains two columns: implicit rowid, A_id.
we create index on A_id.
firstly, we used rowid to select the row, cost about 400 seconds;
secondly, we used A_id to select the row,
Hi , Everyone,
When I use methodone : select * from table_name where rowid = somenumber ?
When I use methodtwo : select * from table_name where ordinaryid =
somenumber ? (ordinary is not index)
The table_name have at least two columns.
I have some questions, as follows:
1.The
Frank Millman Friday, December 11, 2015 9:21 AM
>
> I am having a problem accumulating decimal values.
>
> sqlite> UPDATE fmtemp SET balance = balance + 123.45; SELECT bal FROM
> sqlite> fmtemp;
> 6049.049
>
> Can anyone explain what is going on, and is there a way to avoid it?
>
I *think* this is due to you creating an integer when you first create
the entries
Try changing from
INSERT INTO fmtemp VALUES (1, 0);
to
INSERT INTO fmtemp VALUES (1, 0.0);
Just did
macpro:js rwillett$ sqlite3
SQLite version 3.8.10.2 2015-05-20 18:17:19
Enter ".help" for usage hints.
>
> Mensaje original
> De: Dan Kennedy
> Para: sqlite-users at mailinglists.sqlite.org
> Fecha: Fri, 11 Dec 2015 15:28:33 +0700
> Asunto: Re: [sqlite] Problem when upgrading from FTS3/4 to
> FTS5modules(revisited)
>
>> 1a.- Delete the previous table.
>> DROP TABLE IF EXIST ftsm
>>
On 11 Dec 2015, at 8:29am, ??? <2004wqg2008 at 163.com> wrote:
> 1.Reboot computer
> 2.Shut down computer ,and then start computer
I am sorry to say that ??? (copy and paste, I don't know Chinese !) has given
the first correct answer.
There are at least three levels of caching involved in
Looks like you thought you could have a DECIMAL type (such as MySQL
DECIMAL) here. But SQLite does not allow for this.
My workaround usually is:
create table accounts(account_number integer, balance integer);
create view accounts_view as select account_number, balance /
100.0 from
Hi Frank,
You want to store an INTEGER type using the lowest used unit (cents or mills).
This page https://www.sqlite.org/datatype3.html may be of assistance next time
--
Bernardo Sulzbach
On Fri, 11 Dec 2015 05:14:24 -0700
"Keith Medcalf" wrote:
> Far better is to run the queries multiple times in succession (say,
> 1000) and then average the result.
Good advice. Sometimes it seems like caching is "cheating": we
don't know the performance of something if we're using the cache.
On Fri, Dec 11, 2015 at 8:18 AM, Adam Devita wrote:
> A good start at the long answer can be found in the archives of this list.
>
>
> http://sqlite.1065341.n5.nabble.com/Simple-Math-Question-td85140.html#a85157
> also found at
>
> https://www.mail-archive.com/sqlite-users at
>
A good start at the long answer can be found in the archives of this list.
http://sqlite.1065341.n5.nabble.com/Simple-Math-Question-td85140.html#a85157
also found at
https://www.mail-archive.com/sqlite-users at
mailinglists.sqlite.org/msg04587.html
(web search sqlite "simple math question")
It
On 12/11/15, Frank Millman wrote:
>
> Can anyone explain what is going on, and is there a way to avoid it?
>
Short answer: https://www.sqlite.org/faq.html#q16
I don't have a longer answer readily at hand, but as questions about
floating point numbers come up a lot, probably I should write up a
Hick Gunter wrote:
> 2) run each query in a new process (so each one will need to read the data
> from disk)
This does not help against the file cache of the OS.
Regards,
Clemens
--
> This communication (including any attachments) is intended for the use
> of the intended recipient(s) only
??? wrote:
> For example, tableA contains two columns: implicit rowid, A_id.
> we create index on A_id.
> firstly, we used rowid to select the row, cost about 400 seconds;
> secondly, we used A_id to select the row, cost about 200 seconds;
> thirdly, we also used rowid to
On Fri, Dec 11, 2015 at 8:21 AM, Frank Millman wrote:
> Hi all
>
> I am having a problem accumulating decimal values.
>
> I am actually using Python, but I can reproduce it in the sqlite3
> interactive terminal.
>
> SQLite version 3.8.6 2014-08-15 11:46:33
> Enter ".help" for usage hints.
>
1) disregard the results of the first query timing (this one has to read the
data into the cache)
2) run each query in a new process (so each one will need to read the data from
disk)
-Urspr?ngliche Nachricht-
Von: sqlite-users-bounces at mailinglists.sqlite.org
On 2015-12-11 02:28, ??? wrote:
> The first time your reading from Disk, the 2nd and subsequent times you
> reading from cache
>
> HI,Hick Gunter,
> Thanks for you reply.
> I find a strange problem.
> For example, tableA contains two columns: implicit rowid, A_id.
> we create index on A_id.
There is always an implicit index on the SQLite rowid and this is the fastest
method to locate a row.
The next best thing for retrieval speed is an index that matches the where
clause. If you do not have one, SQLite may decide to create a temporary index
anyway, but this depends on the query.
Actually, you need to pull the power plug after you shut it down for more than
30 seconds, then plug it in and reboot. Only then are you sure the all the
cache has been flushed.
Alternatively, run the test many times (say 1000) and average the results.
> -Original Message-
> From:
> 1) disregard the results of the first query timing (this one has to read
> the data into the cache)
More correctly, you need to exclude the effects of any operation which primes
the cache. This is not necessarily the "first" operation.
Far better is to run the queries multiple times in
On 12/10/2015 05:15 AM, ajm at zator.com wrote:
> Hi list:
>
> In a C++ Windows app that uses SQLite v. 3.9.1 and behaves well, I try change
> the search engine from FTS3/4 modules to FTS5, by means off:
>
> 1. Define the directive
> #define SQLITE_ENABLE_FTS5 1
>
> 2.- Create the table:
>
On 12/10/2015 9:01 AM, michael wrote:
> The statement:
> select distinct text from v_term_item where replace(lower(text),0x0A,'')
> REGEXP('.*/some_text/.*');
> doesn't work like that:
Try x'0A' instead (that's a BLOB literal, and should be converted to a
string). 0x0A is an integer, I suspect
30 matches
Mail list logo
