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 the end of my former email
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,
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 as:
Hash bigint(20) unsigned
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: mysql@lists.mysql.com
Sent: Monday, October 17,
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)
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
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]
To: C.R. Vegelin [EMAIL PROTECTED]
Cc: mysql
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
: [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 ?
I do have a large myisam table with 6 non-unique key
:
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: mysql@lists.mysql.com
Sent: Monday, October 03, 2005 5:25 PM
Subject: Re: How
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 Lib
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
12 matches
Mail list logo