Hi, I did a complex query (long) query and I calculated the time it took to process and put it in a file was about 7.046557 seconds and just do execute the statment it was 4.794579 seconds so 3 seconds to put the results in a file. Now I really please with the results because I am a complete newbie with MySQL.
To learn MySQL with complex query i just created a Match.com thing because i really enjoyed the way the search can be complex and to me it is the only way i could learn. (maybe start with things toooo difficult but still). I have about 21 options for a person i split into 7 tables of 3 columns. where each columns has what i think the most demanded query anyways in those table I put about 129,000 users (all fake users) 40,000 users i'm not looking for and some has a close match to users only 1 or 2 things changes 1,000 users which i'm looking for 20,000 users which i'm not looking for 1,000 users i'm looking for. 10,000 users i'm not looking for 2,000 users i'm looking for 30,000 users i'm not looking for 25,000 users i'm looking for. So i did a query... and limit it to 500 users And I was wondering if these result could be improved timewise maybe I should sort the databases. Any comments is more than welcome Anthony
