No comment, though I am wondering if you have looked at full text search in sql server? If sql server doesn't work for you anymore, I would advise going w/ postgres over mysql.
What is the query that you are running? Likely you can avoid this by making a query that does exists statement vs an IN statement. On Tuesday, September 25, 2012 3:28:18 AM UTC-6, Chris Cartlidge wrote: > > 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/-/IL_Rp00Mw6QJ. 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.
