atching Updates. Without fast disks and/or lots of RAM for caching,
you're not going to get great performance. You just have a lot of
matches to sift through.
On Oct 25, 2005, at 10:32 AM, C.R. Vegelin wrote:
Hi Brent,
Well I did post an EXPLAIN before my query,
but it got squeezed at
indexes it's using. I assume you have both columns
indexed?
On Oct 25, 2005, at 4:46 AM, C.R. Vegelin wrote:
Hi List,
I have a performance problem I can't get solved.
I have 2 tables, called Updates (1 mln rows) and Data (5 mln rows).
Table Updates has 2 (non-unique) keys, defined a
Hi List,
I have a performance problem I can't get solved.
I have 2 tables, called Updates (1 mln rows) and Data (5 mln rows).
Table Updates has 2 (non-unique) keys, defined as:
> Hash bigint(20) unsigned default NULL
> Year tinyint(4) NOT NULL default '0'
Table Data has the same 2 (non-unique) keys
What about renaming the folder indicating the database name.
I work with Windows XP and renaming a folder works well.
Regards, Cor
- Original Message -
From: "Jigal van Hemert" <[EMAIL PROTECTED]>
To: "Octavian Rasnita" <[EMAIL PROTECTED]>
Cc:
Sent: Monday, October 17, 2005 12:11 PM
Su
Hi Jon,
Well, may be the next suggestions might help you.
Disable Keys does apply to non-unique keys only.
So I suggest to focus on your unique Email key.
You could do some tests with:
a. drop the unique key on Email
b. load the various bulks
c. after loading, define Email, eg. as (unique) Primary
d with these 6 non-unique indices in this
case.
In other words, a separate PK index is fully redundant in this case, right ?
In addition, it would save space without the longer concatenate key of
a+b+c+d+e+f.
Thanks, Cor
- Original Message -
From: "Hank" <[EMAIL PROTECTED]&
Hi, I am looking for a method to use variable table names.
I have various download-tables, all having the same structure.
All I want is to run a series of queries on each of these tables.
I tried
SET @mytable = 'Download200501';
SELECT count(*) FROM @mytable;
but this doen't work. Is there any way
rds, Cor
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: Re: How to avoid redundancy between PK and indices ?
"C.R. Vegelin" <[EMAIL PROTECTED]> wrote on 04/10/2005 12:52:01:
Hi List,
Is anyone familiar with optimizing indices, including primary key
Hi List,
Is anyone familiar with optimizing indices, including primary key ?
I do have a large myisam table with 6 non-unique key fields, lets say named A,
B, C, D, E and F.
Each of these columns may have NOT NULL values from 0 to 999, and are defined
as SmallInt.
Requirement: each row must have
the mySQL error messages:
For Each adbError In conn.Errors
MsgBox adbError.Description, vbCritical
Next
It's working !
Thanks again, Cor
- Original Message -
From: <[EMAIL PROTECTED]>
To: "C.R. Vegelin" <[EMAIL PROTECTED]>
Cc:
Sent: Monday, October 03, 2
Hi List,
I want to call the C API functions from Visual Basic in MS Access 2003.
I assume that I have to use: "c:\Program Files\MySQL\MySQL Server
4.1\Bin\LibMySQL.dll".
In my code at module level I have included various code lines to declare
entry-points, such as:
Declare Function mysql_info Li
Hi All,
Does anyone know how to use the format() function in such a way that is
displays numbers right justified.
For example, see the following query, where I want no decimal places:
SELECT 123456.789 AS X, FORMAT(123456.789, 0), FORMAT(123456.789, 0)+0;
The 1st column is normally displayed as 1
12 matches
Mail list logo
