hello,
i have a table with 29 million rows (1,6 Go) with maritime distances inside
working on mysql 3.23.52-Max on a dual xeon 800Mhz 1Go mem
example :
los angeles ----> rotterdam 7728 Nm via panama and english channel
los angeles ----> rotterdam 13456 Nm via cape horn and english channel
port_1 mediumint(7)
port_2 mediumint(7)
distance smallint(5)
way_point1 tinyint(1)
way_point2 tinyint(1)
way_point3 tinyint(1)
way_point4 tinyint(1)
way_point5 tinyint(1)
.....................................
--->
way_point29 tinyint(1)
I'm using 2 multiple column indexes
INDEX 1 (port_1, port_2)
INDEX 2 (port_2, port_1)
response time is not too bad but i wanted to know if someone have an idea
to optimize structure or indexes ?
does tinyint(1) better than enum for boolean value ?
something to do on mysql variables ?
thanks a lot and happy new year !!!
Jean-Fabrice Leoni
Paris France
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
