Web Hosting Geeks | Web Hosting Experts
Need help? Call us 1(866)TOP-HOST

14611 reviews 1734 hosting providers

Questions & Answers

My SQL query takes too long

Jul 17, 2013 by rooby
Hi..
I did a value and variable matching between two big sized tables from MySQL workbench 5.2 the query takes about an hour to finish. The query code I am using is
(select* from tableA as ta1 join tableB as ta2 on (ta1.z=ta2.z and ta1.y=ta2.y and ta1.c=ta2.c and ta1.b=ta2.b) where (abs(ta1.e-ta2.e)<=1)”.
I don’t have  MS SQL server to run this code .
Can anyone please advice
Thank you

1 Answer

0 votes
Jul 17, 2013 by tareq101
You mentioned that you don’t have  MS SQL server to run your code . The best solution for this is to get a free SQL Server Express. http://www.microsoft.com/en-us/sqlserver/editions/2012-editions/express.aspx