Hi, As you guys may know MySQL has an performance issue with "IN" statements ( http://bugs.mysql.com/bug.php?id=9090). Currently we are using a MSSQL quite a few of our search queries use the "IN" statement to perform some sort of filtering and performance is fine.
However, we moved over to MySQL to take advantage of it's full text search and have become stuck with this issue. Has anyone had any experiences with the above and know of any solution? -- ------------------------------------------------------------------------------------ This message and any attachments transmitted with it are confidential and intended solely for the use of the addressee(s). If you are not the addressee, you may not disseminate, distribute or copy this message and you should destroy it and kindly notify the sender by return. All opinions and conclusions in this message are solely those of the author and should be understood as neither given nor endorsed by Adgistics Limited unless specifically stated. Whilst we take reasonable precautions to ensure this message is free of viruses, opening and using this message is at the risk of the recipient. Adgistics Limited: Registered in England and Wales, Company Number: 3859657, Registered Office 5 Copper Row, Tower Bridge Piazza, London SE1 2LH. Vat Registered Number: 752019256. -- You received this message because you are subscribed to the Google Groups "nhusers" group. To view this discussion on the web visit https://groups.google.com/d/msg/nhusers/-/ZWq2j5VK1H0J. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/nhusers?hl=en.
