List:MySQL on Win32« Previous MessageNext Message »
From:Kris Bekkers Date:October 27 2005 12:09pm
Subject:RE: Too Slow Speed
View as plain text  
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.
****************************************************************************
Thread
Too Slow Speedvishal27 Oct
  • Re: Too Slow SpeedDaniel da Veiga27 Oct
RE: Too Slow SpeedKris Bekkers27 Oct