Problem with performance, any way to change the prioority of mysql?

2002-09-04 Thread Tröster Joachim
Hi! We are running mysql (latest 3.x) on Windows 2000 Server. For some reasons I am not allowed to use Linux, so I have to fight my way through windows. All is working fine, I use the "huge".cnf (server is P4 2.w with 1GB RAM) and performance is good. My problem is: When really huge calculatio

Re: problem with performance

2001-02-09 Thread Benjamin Pflugmann
Hi. On Tue, Feb 06, 2001 at 05:14:39PM +0300, [EMAIL PROTECTED] wrote: > Hello Pelle, > > Tuesday, February 06, 2001, 3:49:53 PM, you wrote: > > PE> Hi, > > PE> I think I have a problem with performance. > PE> In my Mysql db I have two tables user (U) and

Re: problem with performance

2001-02-06 Thread Oleg
Hello Pelle, Tuesday, February 06, 2001, 3:49:53 PM, you wrote: PE> Hi, PE> I think I have a problem with performance. PE> In my Mysql db I have two tables user (U) and service (S). PE> I want to read execurl for services registerd on a user ordered by PE> priority. PE>

Re: problem with performance

2001-02-06 Thread Dave Hodgkinson
"Pelle Eliasson" <[EMAIL PROTECTED]> writes: > Hi, > > I think I have a problem with performance. And the EXPLAIN said...? > Before posting, please check: >http://www.mysql.com/manual.php (the manual) It's in the manual... -- Dave Hodgkins

problem with performance

2001-02-06 Thread Pelle Eliasson
Hi, I think I have a problem with performance. In my Mysql db I have two tables user (U) and service (S). I want to read execurl for services registerd on a user ordered by priority. I have made a test program in java (JDBC) that sends select like this I pool connections snd prepared