MySQL Forums
Forum List  »  Performance

Re: optimize IP range join: postgresql is 496 times faster
Posted by: keith cascio
Date: December 10, 2008 12:30PM

Rick,
Thank you for your thoughtful suggestion. Please see my above post for "show create table" output. The query you suggest here does indeed run fast, but I don't think the output is correct. All three assumptions you list do indeed hold. But that query always matches the first row of table range, since the only condition is that the address be greater than or equal to the floor of the range (begin_num).
Keith

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.