SqlDataAdapter.Fill suddenly taking a long time

Posted by WraithNath on Stack Overflow See other posts from Stack Overflow or by WraithNath
Published on 2011-11-03T09:23:51Z Indexed on 2013/06/25 22:22 UTC
Read the original article Hit count: 149

Filed under:

virtual-machine

|

sqldataadapter

I have an application with a central DataTier that can execute a query to a data table using an SQLDataAdapter. None of this code has changed but now all queries are taking at least 10x as long to execute a query returning even one record.

The only difference is that I have been using the app in a VM but the issue has started mid way through using the application. eg, the speed issue has not manifested itself from the start of using the VM, rather half way through.

Has anyone else had an issue with the SQL Data Adapter taking a long time to fill for no reason? executing the query in Management studio it runs in less than a second.

Firewalls are disabled

© Stack Overflow or respective owner

Related posts about virtual-machine

"Virtual Machine Manager" and "Virtual Machine Server" setup manual

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
Is there a manual available that covers the proper setup of a "Virtual Machine Server" with no GUI with an Ubuntu Workstation with a GUI and "Virtual Machine Manager" installed? Both are 12.04 version. I get the following error message: unable to connect to libvirt Verify that -The libvirt-bin package… >>> More
How do the Virtual machine network works ?

as seen on Super User - Search for 'Super User'
I wish to know If I am using 2 VM instance on the same setup and I wish to use heavy data flow between the VMs is there any possibility that I get the Timeout (let say I having one timer on the sending end which stops on getting the ack.) I vague question is How network works in VM . I hope I am… >>> More
Virtual Machine for running Red Hat on Windows Vista

as seen on Stack Overflow - Search for 'Stack Overflow'
It looks like there are a variety of virtual machine offerings available. What is the best one to use with Vista as the host operating system and Red Hat Linux as the guest? >>> More
Virtual Machines List from PowerShell vs PowerShell ISE and PowerGUI

as seen on Server Fault - Search for 'Server Fault'
I am confused to why I have different information based on where I try to retrieve it from. I have 3 Windows 2012 servers (G0, G1, and G2) running Hyper-V. The following situation is captured from one server which I use to run scripts and control the others. What I'm trying to do is to get a list… >>> More
Virtual Box - How to open a .VDI Virtual Machine

as seen on Oracle Blogs - Search for 'Oracle Blogs'
How to open a .VDI Virtual MachineSometimes someone share with us one Virtual machine with extension .VDI, after that we can wonder how and what with?Well the answer is... It is a VirtualBox - Virtual Machine. If you have not downloaded it you can do this easily just follow this post.http://listeningoracle… >>> More

Related posts about sqldataadapter

SqlDataAdapter Update

as seen on Stack Overflow - Search for 'Stack Overflow'
Can any one help me why this error occurs when i update using sqlDataadapter with join query Dynamic SQL generation is not supported against multiple base tables. >>> More
C# SqlDataAdapter not populating DataSet

as seen on Stack Overflow - Search for 'Stack Overflow'
I have searched the net and searched the net only to not quite find the probably I am running into. I am currently having an issue getting a SqlDataAdapter to populate a DataSet. I am running Visual Studio 2008 and the query is being sent to a local instance of SqlServer 2008. If I run the query… >>> More
sql query in the SqlDataAdapter()

as seen on Stack Overflow - Search for 'Stack Overflow'
Im using c# .net windows form application. I have loaded names of all the tables present in a database into a combobox. Now i need to display the contents of the selected table name. Normally we use SqlDataAdapter adp= new SqlDataAdapter("Select * from employee", con); This works fine. but instead… >>> More
How to determine if DataGridView contains uncommitted changes when bound to a SqlDataAdapter

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a form which contains a DataGridView, a BindingSource, a DataTable, and a SqlDataAdapter. I populate the grid and data bindings as follows: private BindingSource bindingSource = new BindingSource(); private DataTable table = new DataTable(); private SqlDataAdapter dataAdapter = new SqlDataAdapter("SELECT… >>> More
How does rolling back an application level transaction interact with SqlDataAdapter events in ADO.NE

as seen on Stack Overflow - Search for 'Stack Overflow'
When utilizing the RowUpdated event in the SqlAdapter class, i'm assuming that it is raised directly following the return of the database interaction that executes the update. If that update is part of an application level transaction (utilizing the SqlTransaction class) which is then rolled back… >>> More