The following query is very slow. I don't know how to improve my query,
and I'm sure I'm doing this just about the slowest way possible!! :(
begin sql query
==
select t1.time, t1.units_processed,
round((t1.units_processed+t2.units_processed+t3.units_processed+t4.units_processe
On Fri, 19 Mar 2004, Fred Williams wrote:
> Yes, about that c.firstname thing...
>
> Do we need to turn in some kind'a formal "enhancement request?" Seems the
> feeling of those responding was that a configurable option was most desired.
> Perhaps a PRAGMA?
>
> So Richard, in all your spare time
-Original Message-
From: Puneet Kishor [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 18, 2004 7:31 PM
To: SQLite
Subject: Re: [sqlite] moving from mySQL to SQLite - A guidance request
> At 3:12 PM -0500 3/18/04, rich coco wrote:
>> I have a legacy app that uses mySQL as the embedded
On Thu, 18 Mar 2004 16:01:39 -0500
"Clark, Chris" <[EMAIL PROTECTED]> wrote:
> > -Original Message-
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> > Sent: Tuesday, March 16, 2004 11:58 PM
> > To: [EMAIL PROTECTED]
> > Subject: Re: [sqlite] SQLite for Win32 TCHAR
> >
> >
> > So f
Dave Hayden wrote:
On Mar 18, 2004, at 1:30 PM, Corporate wrote:
Two words! Thread Synchronization! (above the database API in your
code).
Works like a charm.
I just sat down with a cup of coffee and came to the came conclusion...
It's a shame the MailingList settings are the cause of transformin
At 3:12 PM -0500 3/18/04, rich coco wrote:
I have a legacy app that uses mySQL as the embedded RDBMS.
The app makes explicit invocations to mysql library functions.
There is no ODBC layer being used at all.
What about existing SQL statements (explicit arguments to mysql
function calls) that use
Lay AndrÃs <[EMAIL PROTECTED]>
>Anybody use phpSQLiteAdmin?
>(http://www.phpguru.org/phpSQLiteAdmin.html)
>Because it don't works for me, no error, only it
>redirects to a login.php?SessionID=..., and nothing.
Have you tried SQLiteManager http://sqlitemanager.sourceforge.net/ ? It's extremely
sim
I have a database I have been running for someone else that I have always been able to
view/edit with one of the various GUI interfaces for SQLite. Unfortunately the latest
db update I have, I can't find a program to view the db - I've tried everyone I could
get my hands on, including the comman
When I invoked *setup.py build* in my pysqlite directory, I got the message:
error: command gcc failed with exit status 1
This appeared just after the line
_sqlite.c:1682: (near initialization for `_con_memberlist[2])
That section of _sqlite.c is as follows:
static struct memberlist _con_membe
On Mar 18, 2004, at 1:30 PM, Corporate wrote:
Two words! Thread Synchronization! (above the database API in your
code).
Works like a charm.
I just sat down with a cup of coffee and came to the came
conclusion--if I keep only one connection to the database and do the
mutexing myself, I get bett
Hello Richard
On 03/18/2004, you wrote:
> Do you have session support enabled? Are there any errors displayed ?
Yes, session support enalbed. But NOTHING displayed, only the URL changed
to: login.php?SessionID=...
> And have the second release (dated March, not February).
I tried the version
At 3:12 PM -0500 3/18/04, rich coco wrote:
I have a legacy app that uses mySQL as the embedded RDBMS.
The app makes explicit invocations to mysql library functions.
There is no ODBC layer being used at all.
What about existing SQL statements (explicit arguments to mysql
function calls) that use SQ
On Mar 18, 2004, at 12:14 PM, D. Richard Hipp wrote:
To run a query within a transaction, you also have to compile
it within a transaction. To run a query outside of a transaction
it should be compiled outside of the transaction.
Aha! It's fast again!
Now I have to figure out how to deal with a
I have a legacy app that uses mySQL as the embedded RDBMS.
The app makes explicit invocations to mysql library functions.
There is no ODBC layer being used at all.
I wish to replace mySQL with SQLite.
Since I am bothering to do this, I wish to
introduce an ODBC layer.
I have learned about the exist
On Mar 18, 2004, at 11:28 AM, David Morel wrote:
Le jeu 18/03/2004 à 15:42, Christian Smith a écrit :
| "The problem with the French is that they don't have a word for
entrepreneur"
| George W. Bush
did the man realy SAY that?
Nah:
http://www.snopes.com/quotes/bush.htm
It's a variation on t
Le jeu 18/03/2004 à 15:42, Christian Smith a écrit :
| "The problem with the French is that they don't have a word for entrepreneur"
| George W. Bush
did the man realy SAY that?
ROTFL
--
[EMAIL PROTECTED]
OpenPGP public key: http://www.amakuru.net/dmorel.asc
> Anybody use phpSQLiteAdmin? (http://www.phpguru.org/phpSQLiteAdmin.html)
> Because it don't works for me, no error, only it redirects to a
login.php?SessionID=..., and nothing.
Do you have session support enabled? Are there any errors displayed ? And
have the second release (dated March, not Feb
Hi ML,
after I execute an a sqlite_exec() to insert and/or an sqlite_get_table() to retrieve
data into a table I think
the cursor is then fixed to the end of the recordset so how can I reset its
position to the top of the table without having to close/reopen the db?
Michele Santucci
===
Pierre-Yves Delens wrote:
Bonjour,
as a newbie I'm interested in knowing more about tools you seem to be using
:
- Data-Dumper
- DBI
- DBD-SQLite
(I already know about DbManager, SqLitePlus, SqLiteAnalyzer)
Thanks on forward
DBI: http://search.cpan.org/~timb/DBI-1.42/DBI.pm
DBD-SQLite:
http://s
On Wed, 17 Mar 2004, Dave Hayden wrote:
>I'm inserting a bunch of data loaded off the network into a table. Here
>at the office, SQLite keeps up pretty well; at home on the cable modem,
>it's a huge bottleneck. Loading now takes about 10x what it used to
>when we were just storing in memory. Yes,
Hello HENNINOT
On 03/18/04, you wrote:
> Use SQLiteManager ;-)
> http://sourceforge.net/projects/sqlitemanager
Thank You, i've used it, but the phpSQLiteAdmin looks better by screenshot.
Bye!
Lay
-
To unsubscribe, e-mail: [E
Use SQLiteManager
http://sourceforge.net/projects/sqlitemanager
Le jeu 18/03/2004 à 12:59, Lay András a écrit :
Hello!
Anybody use phpSQLiteAdmin? (http://www.phpguru.org/phpSQLiteAdmin.html)
Because it don't works for me, no error, only it redirects to a login.php?SessionID=..., and nothin
Hello!
Anybody use phpSQLiteAdmin? (http://www.phpguru.org/phpSQLiteAdmin.html)
Because it don't works for me, no error, only it redirects to a
login.php?SessionID=..., and nothing.
What's the problem?
Bye!
Lay
-
To unsubscr
[EMAIL PROTECTED] wrote:
> I'm trying to insert some 1,000 rows a second, with about 200-300 bytes per
> row--it's overview data from an NNTP server. Also, FWIW, this is on OS X and
> I've bumped the page size up to 4096 since that's the memory page size (I
> think), and the rows were exactly the w
24 matches
Mail list logo
