On Fri, Feb 25, 2005 at 07:59:01AM -0500, Brass Tilde wrote :
> > CREATE TABLE All_Chr_CxCb_atleast1 (
> > LOCUSLINK TEXT,
> > GO, BLOB,
> > CAA
build a version up to 10-15% faster
I saw the same kind of speedup (and sometimes up to 25%) depending on
if assertions are enabled. I believe they are enabled by default.
Adding -DNDEBUG turns them off.
Roger
http://www.adtmag.com/article.asp?id=7421
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dv_vstechart/html/vcconMixedDLLLoadingProblem.asp
It's been awhile since Iooked at this, but I distinctly remember
reading from one of the product managers at MS that this wouldn't be
fixed
Hi Appadurai,
>From my experience the stock sqlite.dll is not very fast. I guess it's
build with VC++ 6. Using VC++ 7.1 I was able to build a version up to
10-15% faster, not a bad optimization for 0 lines of code :) . It was a
little bigger, about +25%, but for desktop this is not a problem. I
marco wrote:
Hi *,
Where I can find the list of the internal functions? for example:
datetime()
strftime()
All but the date/time functions are listed in func.c in a table that's
part of sqlite3RegisterBuiltinFunctions(); the date/time functions are
listed in a similar table in
Robert Simpson wrote:
> SELECT games.id, team1_id, team2_id, a.name AS team1, b.name AS team2, result
> FROM games
> INNER JOIN teams AS a ON team1_id = a.id
> INNER JOIN teams AS b ON team2_id = b.id
> WHERE a.name LIKE 'Suns' AND b.name LIKE 'Bulls'
>
> That'll find all games where
Hello,
I send this once some days ago, but it didn't appear on the list,
so i hope this time it'll work out.
I know this is not directly related to SQLite, but hopefully
someone has the time to help me with a (probably) basic SQL question:
Consider the following tables:
CREATE TABLE teams
> CREATE TABLE All_Chr_CxCb_atleast1 (
> TCIDTEXT,
> STRAND TEXT,
> CHROMOSOME TEXT,
> START_POS INTEGER,
Hi Chris,
Thanks for the detailed explanation,
I will dig deeper into my code to see if there is anything wrong in
the OS specific code in my appln.
Anyway thanks for the support.
appadurai
On Fri, 25 Feb 2005 10:33:35 +0530, Neelamegam Appadurai
<[EMAIL PROTECTED]> wrote:
> Hi,
> Thanks for the
> -Original Message-
> From: Neelamegam Appadurai [mailto:[EMAIL PROTECTED]
> Sent: 25 February 2005 05:04
> To: sqlite-users@sqlite.org; [EMAIL PROTECTED]
> Subject: Re: [sqlite] Re: sqlite performance variationin
> linux and windows
>
> Hi,
> Thanks for the quick response and the
Hi,
Neelamegam Appadurai wrote:
Hi,
Thanks for the quick response and the interest you're showing,
I am testing the performance of linux and windows using
a. same testing data for both.
b. db schema is common for both.
c. though the test is conducted on two different machines but the
machine
11 matches
Mail list logo
