Re: Pauses with large selects

2001-03-23 Thread Sinisa Milivojevic
S Lemmon writes: Sinisa Milivojevic wrote: Hi! With : select * from table; queries MySQL returns results immediately. Any problem that you experience might come only from poor build, some OS bug or some wrong settings. Thanks for the reply! That's good

Re: Pauses with large selects

2001-03-22 Thread S Lemmon
Sinisa Milivojevic wrote: Hi! With : select * from table; queries MySQL returns results immediately. Any problem that you experience might come only from poor build, some OS bug or some wrong settings. Thanks for the reply! That's good to know at least. I really didn't know if

Re: Pauses with large selects

2001-03-21 Thread Sinisa Milivojevic
S Lemmon writes: Hi, My main experience is with Informix databases, but am trying MySQL on our web server (ver 3.23.33 running on Linux 2.2.16-3). In general it's working well, but being a MySQL newbie I'm a bit mystified by some odd select behavior. With Informix, doing a

Pauses with large selects

2001-03-20 Thread S Lemmon
Hi, My main experience is with Informix databases, but am trying MySQL on our web server (ver 3.23.33 running on Linux 2.2.16-3). In general it's working well, but being a MySQL newbie I'm a bit mystified by some odd select behavior. With Informix, doing a simple select like "select * from foo"