Executing A SQL Server View From .NET Program Speed?
Mar 1, 2012
I am using VB.NET 2008 and SQL Server 2005.The program runs on a different machine than SQL Server machine.If I read a SQL Server view from my VB.NET program (instead of executing a stored procedure)for ex: Select a,b,c from MyView where account = '1' and symbol = 'abc'will the speed of executing the view depends on the resource (CPU and RAM) of the machine where the program is running or the machine where SQL Server is running ?
Dim m_cmdSQL As SqlClient.SqlCommand
Dim m_daSQL As SqlClient.SqlDataAdapter
Dim m_dsSQL As DataSet
I am using stored procedures in my application using vb.net, while executing stored procedures on mysql database server thru application, the response time from the server is more. Is there any settings that i need to set on mysql db server or any changes in connection string or in code.
I am loading the directories from my C drive into a treeview using the code below. It takes forever due to the number of folders. Is it possible to have this only populate down 1 level and then use a NodeMouseClick Event to drill down further, in the same treeView, if the user desires to do so? How would I amend this code to do this?
we want to write a DLL using VB.NET 2008 using .Net 3.5 that performs an HTTP request we then want to call the DLL From SQL Server 2005 (in a trigger) and pass the DLL some variables and get a return value.Where im at in the process.I have created the DLL 'HTTPDLL.dll'
Source:
Imports System Imports System.Configuration Imports System.Collections.Generic Imports System.Text
[code].....
Perhaps i am calling it incorrectly but i havent been able to get it to work (always return 'invalid class string')
I want to execute a sql server stored procedure in vb using a button. The stored procedure as one variable that is read from a text file.I got it to read the variable from the text file but don't know how to execute the stored procedure.
I was looking at using linq to sql (or EF) rather than in linedynamic sql within my application but have hit a possible issue. My application modifies data against any number of random databases accross several sql instances, linq appears to structured towards a single database scenario. Would it be best to just continue using in line sql or is there a method of using linq without tying it down to a single database? An example of what I'm doing at the moment:
I have a MS SQL Server and 3 client machines, And a program that works on client machines and fetch the data from the MS SQL Server over a 128KBs/64KBs connection speed.
The program works fine but the data fetching and submitting is slow.
I'm asking about any method or idea or technique that can speed up the the access to the MS SQL Server for example database caching or anything like, So that the program can access the database As if it was on the same client machine.
I'm using .net framework 4, vb.net, c#, MS SQL Server 2008 R8, ado.net, Windows 7
I am working on a project, in which I have to run a MATLAB program in VB.NET In the project there is a VB.NET GUI, which contains a browse button. The user has to click on the browse button and select an image for processing. The user then has to click on the Process button for processing the image. After clicking the process button the image selected by the user has to go as input to the MATLAB program.
Q1) I want to know how to give the image selected by the browse button of VB.NET, as input to the MATLAB program for processing?Also while the image is being processed in MATLAB, a message such as "The image is being processed" must be displayed on the VB.NET GUI.
Q2) how to display the message "The image is being processed" on the VB.NET GUI, while the image is being processed in MATLAB?After the image has been processed in MATLAB, the image must be displayed on the VB.NET GUI.
Q3)how to display the image from MATLAB program in VB.NET GUI?
I am trying to execute the shell script in vb.net.[code]...
The script doesn't create the outfile mentioned in -out switch. The path mentioned is correct and also the command with switches is correct. It runs well in command prompt but not in the program. [code]...
I wanna know how could I do to:Assemble a finished program, install it, and leave it executing in second plane to just push a key to work. Execute it once at the windows start and execute just a single key to make it work.I'd like to know what should I put before the assembly
I have a datagridview on my form which displays records from Mysql table on form load.i want to delete the selected row in datagrid from table on 'row header mouse click' event.
The 2 different codes that i tried --- deletes the record from the datagrid for a moment but does not delete from mysql table & re-appears when closed & debugged again.[code]...
I have setup an application to parse about 3000 files a day where each contains around 4000-5000 posts in xml format with like 100 fields.It involves a lot of cleanup and parsing but on average it takes around 6 seconds per post.Now I tried threading but because of the way I have everything set up with variables being overwritten etc...I have divided the files into different folders and just created copies of the program to run and access the assigned folder. It is running on a windows 2008 server with 16 G of memory and I am told I need to reprogram to speed up the process and also not use so much memory.
For i As Integer = 0 To fileLists.Count - 1 Do Try
How do i exactly check internet connection speed.I have searched around google and found out a method w/c will Download a file like 1mb size, then it will calculate the speed.
I have a codes that calculates DownLoad speed and UpLoad speed kb/s. I would like to implement this kind. I also want to put such kind of graph. Any article or links where can I start building my own like that.
I have setup an application to parse about 3000 files a day where each contains around 4000-5000 posts in xml format with like 100 fields. It involves a lot of cleanup and parsing but on average it takes around 6 seconds per post. Now I tried threading but because of the way I have everything set up with variables being overwritten etc...I have divided the files into different folders and just created copies of the program to run and access the assigned folder. It is running on a windows 2008 server with 16 G of memory and I am told I need to reprogram to speed up the process and also not use so much memory.
I'm currently trying to improve the speed of my program. Basically the user inputs min and max values for a, b, c, and d and a constant n, and then it tries to find the curve/line in the form a (x/b + c) ^ n + d. However for large ranges (1-100 for a,b,c, and d; total of 100 million values to try), it would take around 100 minutes at the current rate (approx 800k values/minute). I'm wondering whether I can further improve the speed. [Code]
I would like to execute an external program within powerpoint after the presentation has loaded so i can see if its working. In short my overall objective is to execute the external program which will open up the command prompt and use the sendkeys method to sendkeys to command prompt which help it to run a script at the correct time (which is after presentation is loaded).
I have some difficulties concerning threading [code]
Code: 1- Dim str As String 2- Dim x As New myClass 3- str = x.doSomething() 4- x.closeSomething()
I've included line numbers so I can just refer the lines by their numbers. My problem is, when the program executes, line 4 seems to be executed earlier than I want it to. It gets executed while ThreadX is still running in line 3. How can I force the program to wait until ThreadX has finished executing, before it executes line 4?
I am trying to create a program in Visual Basic which will measure the performance of the CPU with every core, one at a time. In this program, I decided to place a couple of text boxes that display the processor speed and the actual processor speed. I need to get the actual processor speed to update and I have tried doing this already using a timer set to tick every second. However, when I load the program it runs really slowly and prevents me form doing anything within the program, including trying to close it down, and all it does is updates the text box every second. I have looked in task manager to find out how much CPU the program is using and it shows that my program is using 0 - 3% CPU.
Here is the code currently use
Private Sub Timer3_Tick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Timer3.Tick Dim mSearcher As New ManagementObjectSearcher("SELECT * FROM Win32_Processor")
I've written an algorithm that I believe to be correct for computing prime numbers up to n with the Sieve of Eratosthenes. Unfortunately, this program hangs on really large values of n (try 10 million). Here is what I've written...
Protected Function Eratosthenes(ByVal n As Integer) As String Dim maxValue As Integer = Math.Sqrt(n) Dim values As Generic.List(Of Integer) = New Generic.List(Of Integer)
[code]...
How might I speed this algorithm up? Where are my bottlenecks?
