Left join query

Airport table SlNoName Code AuthLocation status 1 ChennaiCHN Yes India 1 2. Hydarabed HYD Yes India 0 3 walkerWAK Yes uk1 common table SlNoName Code

Re: Why can't I kill the query cache?

You can also flush the cache with echo 1 > /proc/sys/vm/drop_caches if you have a new enough kernel. On Fri, May 29, 2009 at 2:16 PM, Dan Nelson wrote: > In the last episode (May 29), Gerald L. Clark said: >> Little, Timothy wrote: >> > Also titled, I want this to run slow ALL the time... >> > >>

Re: Why can't I kill the query cache?

In the last episode (May 29), Gerald L. Clark said: > Little, Timothy wrote: > > Also titled, I want this to run slow ALL the time... > > > > I have a group of dreadful queries that I have to optimize. > > > > Some take 20-30 seconds each -- the first time that I run them. But > > then they ne

Re: Why can't I kill the query cache?

Little, Timothy wrote: Also titled, I want this to run slow ALL the time... I have a group of dreadful queries that I have to optimize. Some take 20-30 seconds each -- the first time that I run them. But then they never seem to take that long after the first time (taking less than a second

Why can't I kill the query cache?

Also titled, I want this to run slow ALL the time... I have a group of dreadful queries that I have to optimize. Some take 20-30 seconds each -- the first time that I run them. But then they never seem to take that long after the first time (taking less than a second then). If I change the "k