Sorting really doesn't make much different... The index is what stops
mysql from reading through the entire table instead of just grabbing a
few needed rows.
CREATE TEMPORARY TABLE semantic_drilldown_values (
id INT NOT NULL,
INDEX id_index (id)
) AS SELECT ids.smw_id AS id FROM ...
Something along that lines. Basically instead of doing the SELECT
statement, and having it assume what kind of table to create, you give
it the structure then let the SELECT fill THAT table instead of being
used to understand what kind of table to create. And in the table's
structure you add the definition for the index.
~Daniel Friesen(Dantman, Nadir-Seen-Fire) of:
-The Nadir-Point Group (http://nadir-point.com)
--It's Wiki-Tools subgroup (http://wiki-tools.com)
--The ElectronicMe project (http://electronic-me.org)
--Games-G.P.S. (http://ggps.org)
-And Wikia ACG on Wikia.com (http://wikia.com/wiki/Wikia_ACG)
--Animepedia (http://anime.wikia.com)
--Narutopedia (http://naruto.wikia.com)
Yaron Koren wrote:
Well, actually, "ALTER TABLE" is currently called in two different places in
the code, to add an index to two different temp tables: one holds just an
integer column, while the other holds an integer and a string column. In
both cases, the index is being added to the integer column. I suppose the
table could just be sorted on that column in both cases; I don't know why I
didn't do that. Would that have the same performance effect as indexing?
-Yaron
On Thu, Aug 28, 2008 at 3:32 PM, Daniel Friesen <[EMAIL PROTECTED]>wrote:
Well, to start... what is the structure of the table that the current
query creates?
------------------------------------------------------------------------
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
------------------------------------------------------------------------
_______________________________________________
Semediawiki-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/semediawiki-devel
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Semediawiki-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/semediawiki-devel
