Too Slow Speed

------=_NextPart_000_0005_01C5DAF9.44CACB20
Content-Type: multipart/alternative;
boundary="----=_NextPart_001_0006_01C5DAF9.44CACB20"


------=_NextPart_001_0006_01C5DAF9.44CACB20
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

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 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.

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

Thanking You and Congratulation for a Great Revolution over the field of =
RDBMS.=20

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
------=_NextPart_001_0006_01C5DAF9.44CACB20
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable



charset=3Diso-8859-1">

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 fro=
m
> Microsoft Access To MySQL. But when I implement it there was a problem wi=
th

Wise choice.

> MySQL about speed matters. Here by I have attached a code which represent=
s
> 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=3Dgcdmw-win32@m.gmane.org

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-director=
y and the temp-directory (tmpdir in the config file)
At least, it gave a performance boost of about 150% at my develloping mac=
hine.

Kris

-----Original Message-----
From: Daniel da Veiga [mailto:danieldaveiga@gmail.com]
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 f=
rom
> 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 represe=
nts
> 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 o=
f
> 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------

--=20
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dkris.bekkers@atos=
origin.com
************************************************************ *************=
***
Disclaimer:=20
This electronic transmission and any files attached to it are strictly=20
confidential and intended solely for the addressee. If you are not=20
the intended addressee, you must not disclose, copy or take any
action in reliance of this transmission. If you have received this=20
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=20
resulting from any virus transmitted.=20
Thank You.
************************************************************ *************=
***

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org