List:MySQL on Win32« Previous MessageNext Message »
From:Jorge Bastos Date:October 27 2005 1:16pm
Subject:Fw: Too Slow Speed
View as plain text  
At least the Macfee turns the server very slow, i say this with my own 
experience.


----- Original Message ----- 
From: "Bekkers, Kris" <Kris.Bekkers@stripped>
To: "Daniel da Veiga" <danieldaveiga@stripped>; "MySQL Win32 List" 
<win32@stripped>
Sent: Thursday, October 27, 2005 1:09 PM
Subject: RE: Too Slow Speed


Collegeaus,

I also found out that some virus-scanner could interfere with the speed.
If anny scanner used - try disabeling the scanning from the data-directory 
and the temp-directory (tmpdir in the config file)
At least, it gave a performance boost of about 150% at my develloping 
machine.

Kris

-----Original Message-----
From: Daniel da Veiga [mailto:danieldaveiga@stripped]
Sent: donderdag 27 oktober 2005 14:05
To: MySQL Win32 List
Subject: Re: Too Slow Speed


On 10/27/05, vishal <vishal@stripped> wrote:
> Respected Sit / Madam,
>
> I was motivated by your site and much inspired to convert my software from
> Microsoft Access To MySQL. But when I implement it there was a problem 
> with

Wise choice.

> MySQL about speed matters. Here by I have attached a code which represents
> the timing taken to store the 500 records both in Access and MySQL.

Couldn't see the attachment (better, couldn't find any useful info on
them) and ignored the 4 copies of this email you sent us.

>
> It might be my mistake but please inform us whatever the solutions may be 
> or
> not.

OK, so, you're using ODBC, MyODBC 3.51 (latest, I belive), and
connecting to localhost (since you mentioned no details of your
connections, I believe it is local). Well, that's not much info so its
hard to help you, as you can see if you test the queries using the
console, MySQL is fast and reliable. I used ODBC with ADO objects in
VB using remote connections and it was pretty fast, even across long
distances, so, its probably the configuration of your server or the
way you're sending queries.

>
> Thanking You and Congratulation for a Great Revolution over the field of
> RDBMS.
>
> Eagerly waiting for your solution to implent the MySQL.
>
> Details for the Test :
>
> Platform : Windows 2003 Server
> Langauage : Visual Basic 6.0 (SP 5)
> Connectivity : MySQL 3.5
>

What can I say?! Test for DNS resolution tries, check your config file
for network related issues, like bind-address and resolving. Test
connections and check (this was Shawn tip) if you're not openning and
closing the connection for each insert.

Give us more info and you'll get more feedback I'm sure.

Good luck,

--
Daniel da Veiga
Computer Operator - RS - Brazil
-----BEGIN GEEK CODE BLOCK-----
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
------END GEEK CODE BLOCK------

-- 
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: 
http://lists.mysql.com/win32?unsub=1
****************************************************************************
Disclaimer:
This electronic transmission and any files attached to it are strictly
confidential and intended solely for the addressee. If you are not
the intended addressee, you must not disclose, copy or take any
action in reliance of this transmission. If you have received this
transmission in error, please notify the sender by return and delete
the transmission.  Although the sender endeavors to maintain a
computer virus free network, the sender does not warrant that this
transmission is virus-free and will not be liable for any damages
resulting from any virus transmitted.
Thank You.
****************************************************************************

-- 
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:    http://lists.mysql.com/win32?unsub=1



Thread
Fw: Too Slow SpeedJorge Bastos27 Oct