what do you think of speed

2003-07-25 Thread awards
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

optimization

2003-07-24 Thread awards
Hi, I read at MysQl.com about Explain SELECT, it says at then end of a paragraph to optimize your query, using filesort or temporary, but I went to MySQL search engine no luck on finding them, can someone explain me both type. **What i'm doing, since I'm using mysql for a program*** **I

Re: MySQL on a website

2003-07-23 Thread awards
Hi, I doubt you will find free host for MySQL because you seem to use ASP, which is really not commun and i have not seen many host (paid host) provide ASP may be i have looked at the wrong place. Anyhow if you decide to use php then you will have more chance to find free host with MySQL, I