I wouldn't imagine that creating an index on a column with only two possible
values could make things any faster. You only get a maximum 50% reduction
in row scans, rather than the normal log based reduction with a random value
distribution. In addition, you contend with the overhead of using
table.
MySQL usually detects this and ignores the index, especially if another
index was already used to break down the number of rows.
Matt
-Original Message-
From: Balazs Rauznitz [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 20, 2004 2:46 PM
To: Matt Griffin
Cc: [EMAIL PROTECTED
Ignore that silly equation. I tried to simplify and ended up with something
mathematically ridiculous. I'm sure someone can come up with a more
accurate simplification.
Matt
-Original Message-
From: Matt Griffin [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 20, 2004 3:46 PM
I have been using adjacency lists to solve problems with hierarchical data.
The algorithm is described in a relatively database independent way here:
http://www.intelligententerprise.com/001020/celko1_1.shtml
And by the same author here: http://www.dbmsmag.com/9603d06.html
Includes a tiny bit
There's no way to hide a row. However, I can think of a zany solution.
Update your tables using a hash of all the data in the row. That way you
don't need an id field.
Fair warning: this is not a GOOD solution but it does address the problem.
Matt
-Original Message-
From: Stéphane
If the the file is on the same machine as your shell is running,
specify --local when running mysqlimport.
Matt
-Original Message-
From: Pawe Filutowski [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 09, 2003 10:27 AM
To: [EMAIL PROTECTED]
Subject: Problem with mysqlimport
I tryed
MySQL doesn't return HTTP error codes.
Your problem is not with mysql but with Dreamweaver's browser not being
pointed at a running webserver. Did you set up Apache (or some other
server) when you set up PHP and prove that both are functioning?
Matt
-Original Message-
From: Lost Idols
- Original Message -
From: Matt Griffin [EMAIL PROTECTED]
To: 'Pawe3 Filutowski' [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Tuesday, December 09, 2003 5:11 PM
Subject: RE: Problem with mysqlimport
If the the file is on the same machine as your shell is running,
specify --local when running
operators.
Matt Griffin
Software Developer
Nerac, Inc.
One Technology Drive
Tolland, CT 06084
phone: 860-872-7000, ext. 328
[EMAIL PROTECTED]
www.nerac.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]