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 3 1064
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" <Fr***@discussions.microsoft.com> wrote in message
news:76**********************************@microsof t.com... 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
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" <Fr***@discussions.microsoft.com> wrote in message news:76**********************************@microsof t.com... 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
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" <Fr***@discussions.microsoft.com> wrote in message
news:EB**********************************@microsof t.com... 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" <Fr***@discussions.microsoft.com> wrote in message news:76**********************************@microsof t.com... > 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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: AMC |
last post by:
Hi,
I'm using an include file to store the connection string to a database.
Whenever I try to reference that string to open a connection in the page
that includes the file I get the error 'empy...
|
by: David.Tymon |
last post by:
>Description:
MySQL v4.1.0-alpha only allows a client to prepare a maximum of 254
statements. On the 255th mysql_prepare() call, a failure is returned
with no information returned by...
|
by: Pav Lucistnik |
last post by:
Hi folks,
we're seeing strange behaviour of mysql connections over network here
lately. Server and client are on different machines. Server (corpdb) is
Mysql 3.23.52 on FreeBSD 4.6.2-RELEASE,...
|
by: chris |
last post by:
I open MySQL Manager and connect to my database.
I then insert one record in to an InnoDB table in MySQL (4.0 and 4.1
alpha hosted on XP running mysqld --console).
I then retrieve the record...
|
by: Peter Höltschi |
last post by:
I try to install MySQL Connection/J on a Windows XP box. MySQL on
localhost works fine. But I cannot load the MySQL Connection/J Driver.
The CLASSPATH variable is set like this:...
|
by: Ian Davies |
last post by:
Hello
I have the following code to connect to mySQL database from VB6
********************************************
Private Sub Form_Load()
Dim conn As ADODB.Connection
Set conn = New...
|
by: BillCo |
last post by:
I need to Connect to an online mySQL database from Access using JET
ODBC with no saved DSN.
Anyone out there who as made this work and can give example of how
it's done? I've seen lots of posts...
|
by: Hetal |
last post by:
Hi...
I am a newbie VB.NET developer and i am looking at working with
ADO.NET rather than ADO. In one of our native VB application with ADO,
we used to create 1 connection object and that would...
|
by: tulika dutta |
last post by:
after 8 hrs my MySQL connection with JDBC gets time out. It gives the error
java.sql.SQLException: No operations allowed after connection closed.Connection was implicitly closed due to underlying...
|
by: bartonc |
last post by:
This is a work in progress (current and active).
There are some issues to resolve in supporting multiple connection types and I plan to add PySQLite to the mix. The this update is due to my...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
|
by: ryjfgjl |
last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
| |