Re: ASP.Net Connection To MYSQL

hmm, strange. i'd open a support call to the provider to see if they have a
fix/workaround for this situation. I have found them very responsive to bugs
of that nature in the past.

--
________________________
Warm regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
Professional VSTO.NET - Wrox/Wiley
The O.W.C. Black Book with .NET
www.lulu.com/owc, Amazon
Blog: http://www.msmvps.com/blogs/alvin
-------------------------------------------------------


"Frank" <Frank@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:EBD2600A-2A0A-4AC6-A02D-C87E0EF13240@xxxxxxxxxxxxxxxx
Alvin, thanks for the response. I do have the latest provider loaded. What
I
did find after reading some other threads is that if I disconnect my
network
cable the queries fly. It seems to have something to do with DNS which is
posted a lot with relation to the speed issue. In short, since all tools
and
databases are local to this machine, if not connected to the network,
everything works great.

Any additional feedback is appreciated. Thanks again, Frank

"Alvin Bruney [MVP]" wrote:

You need to connect using the latest native mysql provider. mysql is
extremely fast so it is possible that your problem lies elsewhere. Have
you
tried tracing the query statements in the db layer?

--
________________________
Warm regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
Professional VSTO.NET - Wrox/Wiley
The O.W.C. Black Book with .NET
www.lulu.com/owc, Amazon
Blog: http://www.msmvps.com/blogs/alvin
-------------------------------------------------------


"Frank" <Frank@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:7665B978-DE2A-4BBE-9BD0-DA4F3E79A597@xxxxxxxxxxxxxxxx
Hello, I am writing an ASP.Net (Visual Basic) application with a MYSQL
backend.
I connect fine with the DataProvider and also ODBC. I Retrieve records
with
no problem. I INSERT Records with no problem. The problem is that is is
SLOW.
For example, to retrieve 4 records from the database table, it takes
several
seconds. In Addition, I am developing on a local machine. There are no
trips
to a remote server at this point. I see posts out there that some folks
have
a slowness issue and others say everything is great and fast. Can
anyone
assist with this?
Would prefer to us SQLServer as the backend, but have to conform to the
installation at present.

Thanks, Frank





.

Relevant Pages

  • Re: Replication as a Performance Enhancer?
    ... And, if there is a need to have them work with multiple reocrds, but that's ... Or, alternativesly, can put each subform on its own tab in a tabbed ... leading me to believe the network has a lot to do with it. ... was bring in the MDW file to his local machine, ...
    (comp.databases.ms-access)
  • Re: Managing outlook archive settings using exchange/gpo
    ... Archiving or deleting items reduces the used space in the databases, ... Get the ADM files and install the Outlook 2003 ... then copy the archive.pst files to a network share for backup or other ...
    (microsoft.public.windows.server.sbs)
  • Re: Managing outlook archive settings using exchange/gpo
    ... Archiving or deleting items reduces the used space in the databases, ... Get the ADM files and install the Outlook 2003 ... then copy the archive.pst files to a network share for backup or other ...
    (microsoft.public.windows.server.sbs)
  • RE: Secure Network Design (DMZ, LAN, etc)
    ... webservers acting as routers so that they can get to your databases on ... then why have a separate network? ... interface on your internal firewall which protects the innermost network ... switch. ...
    (Security-Basics)
  • Can Access handle this configuration, or do I need SQL Server?
    ... We have about twenty Access 2002 databases with the front ends in the four ... performance is not a problem; but over the network ... or do I need to scale up to MSDE or SQL Server? ... post this question in the SQL Server or MSDE newsgroups, ...
    (microsoft.public.access.formscoding)