From: Date: October 27 2005 3:16pm Subject: Fw: Too Slow Speed List-Archive: http://lists.mysql.com/win32/17695 Message-Id: <012d01c5daf8$9e063a40$0301a8c0@hercules.decimalint.pt> MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original Content-Transfer-Encoding: 7bit At least the Macfee turns the server very slow, i say this with my own experience. ----- Original Message ----- From: "Bekkers, Kris" To: "Daniel da Veiga" ; "MySQL Win32 List" 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 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=kris.bekkers@stripped **************************************************************************** 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=mysql.jorge@stripped