Hi Maurice, I would be interested to see how your SQL reuqest looks like. Perhaps it is possible to optimize at this point, just a guess so.
Best regards Nils Valentin Tokyo/Japan 2003年 6月 27日 金曜日 18:34、Maurice Coyle さんは書きました: > hi all, > i have a table in my mysql database with around 66 million rows in it. > when i query this table, it takes anywhere from 3 minutes to 10 minutes to > return the results. i've tried this both from within the mysql command > line and from java programs. > > Section 1.2.4 in the manual says the maximum table size is 4Gb and when i > use the show status command for this table, it says the data_length is > 1,585 947,820 and the max_data_length is 4,294,967,295, so the table size > seems to be well within the limit. > > The results for a query to this table can contain up to 11500 hits, so > maybe this is the problem? If there's no fix for this, does anyone know > how i can query for only the top 100 results, say? > > i can't see what's wrong, can anyone shed some light on this problem/offer > the benefit of your experience in similar matters? i'd really appreciate it > if you could. > > thanks, > maurice -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
