Hi all
We are having a weird problem with some queries which are not using some
indexes in date fields.
Query-1
SELECT [field list] FROM tableX
WHERE dateField = [any date expression or constant value]
Query-2
SELECT [field list] FROM tableX
WHERE dateField = [any date expression or constant
-Original Message-
From: Aftab Khan [mailto:[EMAIL PROTECTED]
Sent: 05 January 2006 11:03
To: Javier Diaz
Subject: Re: Problems with indexes on Date/DateTime fields
Is not the second quary doing a full table scan? The
parser may find this better than using the Index.
--- Javier Diaz
if that is
the case we will need to re-visit a few queries
Thx
Javier
-Original Message-
From: Aftab Khan [mailto:[EMAIL PROTECTED]
Sent: 05 January 2006 11:25
To: Javier Diaz
Subject: RE: Problems with indexes on Date/DateTime fields
I agree. Some time full table scan is faster than
using
]
Are valid for the equivalent
DELETE FROM TABLE-X WHERE [CONDITIONS]
Thanks a lot for your help
Javier
-Original Message-
From: Jigal van Hemert [mailto:[EMAIL PROTECTED]
Sent: 05 January 2006 14:39
To: Javier Diaz
Cc: Aftab Khan; mysql@lists.mysql.com
Subject: Re: Problems with indexes on Date
Hi
Instead of use two INSERT statements, try something like this:
INSERT INTO Table table1 VALUES (list of values1), (list of values2)
-Original Message-
From: Jeremiah Gowdy [mailto:[EMAIL PROTECTED]
Sent: 06 May 2005 17:19
To: [EMAIL PROTECTED]; mysql@lists.mysql.com
?
I would appreciate any ideas you can have, we really need this ASAP.
Thanks
Javier`
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 02 July 2004 10:42
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: Concurrency Question
Javier Diaz [EMAIL PROTECTED
To: Javier Diaz
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: Concurrency Question
On Mon, 5 Jul 2004 16:07:58 +0100 , Javier Diaz [EMAIL PROTECTED]
wrote:
We have changed all our tables to InnoDB and now the server is not able to
handle the load, even when we are not running the SELECTs
Hi everyone
We have some tables to record different data of the activity in our website.
The number of INSERT, DELETE and UPDATE operations in these tables is huge
(it could be more than 3000 a second). So far we don't have any speed
problems, all these tables are optimised using the right
Hi everyone
I need have a row counter in a query but I'm not sure if there is any way to
do this. In essence all I need is get a result like this:
Counter column-A column-B
1 A-1 B-1
2 A-2 B-2
: : :
:
version of dbExpress, it would be
good if you would write to Borland people about this, or to the Borland
newsgroups.
Regards,
Heikki
Innobase Oy
- Original Message -
From: Javier Diaz [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Monday, September 02, 2002 3:06 PM
Subject: Inno DB
?
Thanks a lot
Javier Diaz
--
This e-mail is intended for the named addressee only. It may contain confidential
and/or privileged information. If you have received this message in error, please let
us know and then delete this message from your system. You should
-
From: Tod Harter [mailto:[EMAIL PROTECTED]]
Sent: 02 September 2002 15:58
To: Javier Diaz
Subject: Re: Inno DB Question
On Monday 02 September 2002 07:37 am, you wrote:
I would think you would want to set autocommit BEFORE you call BEGIN since
that starts your transaction. My guess would
12 matches
Mail list logo