Dedicated Hosting Provider
February 9th, 2010
How to optimize MySql query that needs a lot of: “Like %’$var’%”?
I need to search many fields in multiple tables using Like %’$var’% in my queries, but my hosting provider blocked my UK swift code database because it overloaded their server. Any suggestions? I cant afford a dedicated server.
Hello,
I have used mysql directly, however one practice that my company uses with SQLServer is to use Nolocks on tables.
The syntax for Sqlserver is “select * from TableA (Nolock) …”
Also if you are seraching a field in my different tables you could insert the data from all the tables into a temp table and then do a serach only on the
temp table.
Codero: Dedicated & Managed Hosting Provider TV Interview
|
|
JDA Software selects Layered Tech as dedicated, hosting-infrastructure provider.(CONTRACTS): An article from: Green Data Centers & Internet Business $9.95 This digital document is an article from Green Data Centers & Internet Business, published by Information Gatekeepers, Inc. on April 1, 2010. The length of the article is 335 words. The page length shown above is based on a typical 300-word page. The article is delivered in HTML format and is available immediately after purchase. You can view it with any web browser.Citation DetailsTitle: JDA Soft… |