List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:January 17 2001 1:09am
Subject:Re: Why does query hang? [was: Why does 1st query take so long?
View as plain text  
In the last episode (Jan 17), John Stumbles said:
> SELECT * from MAC_connections
> 	or even
> SELECT count(*) from MAC_connections
> 
> hangs! (it's been sitting there for the last 10 minutes and hasn't
> produced anything!)

The server always caches the value of count(*), so the only reason it
couldn't return the result to you would be if the table was locked by
another process doing a long UPDATE or DELETE query; are there any
other queries being run at the same time?

-- 
	Dan Nelson
	dnelson@stripped
Thread
Why does 1st query take so long?John Stumbles16 Jan
  • Re: Why does 1st query take so long?Jeremy D. Zawodny16 Jan
    • Re: Why does 1st query take so long?John Stumbles16 Jan
      • Re: Why does 1st query take so long?Jeremy D. Zawodny16 Jan
        • Why does query hang? [was: Why does 1st query take so long?John Stumbles17 Jan
          • Re: Why does query hang? [was: Why does 1st query take so long?Drew Wilder-Goodwin17 Jan
          • Re: Why does query hang? [was: Why does 1st query take so long?Dan Nelson17 Jan
            • Re: Why does query hang?John Stumbles17 Jan
              • Re: Why does query hang?Dan Nelson17 Jan