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
faster to scan the whole 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 Gri
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 the
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 more
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 Bis
?
Regards
- 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
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 [
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 t
proximity 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]
