Re: Connection performance, suggestions?

2005-01-24 Thread Larry Lowry
- Original Message - From: Donny Simonton [EMAIL PROTECTED] To: 'Larry Lowry' [EMAIL PROTECTED]; 'Peter J Milanese' [EMAIL PROTECTED]; mysql@lists.mysql.com Sent: Saturday, January 22, 2005 7:34 PM Subject: RE: Connection performance, suggestions? Attempt to connect to mysql via ip address

Re: Connection performance, suggestions?

2005-01-24 Thread Dan Nelson
In the last episode (Jan 24), Larry Lowry said: Ok I changed my connection string to use the IP of the mySql box and added my workstation to the hosts file on the server. Same problem. The tests ran at the same slow pace. I am really curious, what was the logic of adding the workstation ip

Re: Connection performance, suggestions?

2005-01-22 Thread Larry Lowry
- From: Peter J Milanese [EMAIL PROTECTED] To: Larry Lowry [EMAIL PROTECTED] Sent: Saturday, January 22, 2005 10:22 AM Subject: Re: Connection performance, suggestions? You are not simulating. Your scripting produces 100 linear connections. You are attempting, by theory, to simulate simultaneous

RE: Connection performance, suggestions?

2005-01-22 Thread Donny Simonton
To: Peter J Milanese; mysql@lists.mysql.com Subject: Re: Connection performance, suggestions? Actually I was just trying to see why the same code to mySql is so much slower than SQL Server. I tried the same code using the data provider from CoreLabs and found the connections occur 4 times faster than

Connection performance, suggestions?

2005-01-21 Thread Larry Lowry
Before I ask this question I must state I love mySql and want to use it more. But I work in a shop were we mostly use SQL Server 2000. In trying to use mySql (4.12 and 4.19) we are seeing some performance issues. I hope someone can help me with this. I am in a Windows 2003 server environment

Re: Connection performance, suggestions?

2005-01-21 Thread Peter J Milanese
performance, suggestions? Before I ask this question I must state I love mySql and want to use it more. But I work in a shop were we mostly use SQL Server 2000. In trying to use mySql (4.12 and 4.19) we are seeing some performance issues. I hope someone can help me with this. I am in a Windows 2003

Re: Connection performance, suggestions?

2005-01-21 Thread Larry Lowry
Subject: Connection performance, suggestions? Before I ask this question I must state I love mySql and want to use it more. But I work in a shop were we mostly use SQL Server 2000. In trying to use mySql (4.12 and 4.19) we are seeing some performance issues. I hope someone can help me with this. I am