is:
Edward Lau@T60p ~/myCprograms
$ gcc --version
gcc.exe (GCC) 4.8.1
$ gcc -shared -O2 -o benchmark.dll benchmark.c
Edward Lau@T60p ~/myCprograms
$ sqlite3
SQLite version 3.8.7.4 2014-12-09 01:34:36
Enter .help for usage hints.
Connected to a transient in-memory database.
Use
by comparison. As we transition to SSD the IO latency
drops and bottlneck shift back to code.
Comments and suggestions? Merry Christmas everyone.
THE RAW LOGS:
=
Edward Lau@T60p ~/myCprograms
$ gcc --version
gcc.exe (GCC) 4.8.1
Copyright (C) 2013 Free Software Foundation, Inc
sqlite3_extension_init(sqlite3 *db ,char **ppzErrMsg ,const
sqlite3_api_routines *pApi )
{
return myVirtualTable_init( db ,ppzErrMsg ,pApi );
}
THE RAW LOGS:
=
Edward Lau@T60p ~/myCprograms
$ gcc --version
gcc.exe (GCC) 4.8.1
Copyright (C) 2013 Free Software Foundation, Inc
Re-posting due to message size too long.
Hi Folks:
I have read in many posting that SQLite is fast. How fast is fast? So over
this holiday break I tried to take a reading on the VDBE performance to get a
general idea. I wrote a quick module to enable me to exercise the engine
simulating
Hi SQLite team:
I cast my vote for some analytic functions too.
-Original Message-
From: big stone stonebi...@gmail.com
To: sqlite-users sqlite-users@sqlite.org
Sent: Sun, Dec 21, 2014 1:47 am
Subject: [sqlite] Whish List for 2015
Hi all,
To prepare for end of 2014 greetings
Hi SQLite Team:
I second Nico's suggestion. We are finding new usage with SQLite especially
with virtual tables. I understand the teams commitment to backwards
compatibility. Maybe some time in the future a version 4 be started that
incorporates many new advancement in the industry.
, 2014 2:09 pm
Subject: Re: [sqlite] SQLite as a meta database
On 5 Nov 2014, at 9:28pm, Edward Lau elau1...@aim.com wrote:
Maybe some time in the future a version 4 be started that incorporates many
new advancement in the industry. Version 3 can still be continued for
backwards
compatibility
Hi Eduardo:
As Petite have mention, the following query
selectid, category_id, name, min(price) as minprice
from cat_pictures
group by category_id;
is missing the id and name columns in the GROUP BY clause ... per standard
SQL standard requirement. If the above works, it is a
SQL Server 2008 does not have this behaviour.
SELECT id, category_id, name, min(price) as minprice
FROM(
SELECT 1 id ,1 category_id ,'name1' name ,1 price -- Generate some
data.
) AS cat_pictures
GROUP BY category_id;
produced:
Msg 8120, Level 16, State 1, Line 3
Hi Peter:
Specifically, if you are going to use SQL Server Integration Services (SSIS)
you can specify LF as the record delimiter. It defaults to {CR}{LF} but you
can change it in the FlatFile Connection Manager under the Advance tab.
-Original Message-
From: Peter Waller
Out of curiosity, I wrote a loadable module to benchmark sqlite3 in a 32
million iterations loop doing nothing to gauge its performance. There is no
I/O from querying any tables. The rows are artificially created from
incrementing an integer counter. 32 million rows is about the normal size
Hi Jose:
In SQL, aggregate function cannot be used in the WHERE clause. Use the HAVING
clause instead.
Try this:
SELECT cust,
ProjID,
proj,
A_No,
bdate,
CASE Xtra4 WHEN 'y' THEN vEmail ELSE 'noemail' END,
sum(ProjFund),
sum(ProjFund)-sum(CASE
12 matches
Mail list logo