I have a backend database in MS access, which is updated using excel as front end. Due to network issues the record updation takes lot of time. Would it be faster if i use VB.net as the front end.
View 1 RepliesI am on one asignment of convering C# to VB.net and stuck up with this problem.C# application has one class having inline two dimensional array initialized with size 168X168. I converted same class to Vb.net. Now whenever I create instance of my this VB.net class, It take almost 3 minute.
To figure out problem, I put break point on sub new() (first line of my constructor), and behaviour is realy strange because it takes 3 minutes to reach at first point of my constructor.Whenever I comment out my large size array initialization code, It works perfect. Now please note that same code is working fine in C#. It is not taking even few millisecond to initialize that class.
I am writing an application for managing mp3 files. I use AXWindowsMediaPlayer1 for playing files and UltraID3 for reading and writing ID3 tags. Every time the user selects to switch to next song, the ID3 tags of the current file need to be updated. My problem is with Media Player taking a long time to release a file for access after doing a "close". Currently I need to add a 6 seconds delay between the "Close" method of the media player and the ID3 tag "Write", otherwise I get the error saying that the file is currently in use. Anything less than 6 seconds does not work...
I attached a short version of my application which focuses on the issue.
I'm writing a program to search files.The result is saved in a text file.Everything it's working fine, but when I say to look for files/folders in C:* the process takes long time and in task manager it's displayed as "Not Responding", this is not true because I see that CPU and RAM are working with this process.I've disabled in DEBUG OPTIONS the line "ContextSwitchDeadlock" just to prevent the error message "this operation require long time ... bla bla bla".Is there any way to display a progress bar or something like that that shows the program is running and it isn't "hang"?Here's my code (in red the line where the program hangs):
Code:
Public Class Form1
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim cartella, scelta, cosa As String
[code]....
I think that it's like when you type in the command prompt "tree" it doesn't hang... I know... it's not the same thing but...I'm using Visual Basic 2008 Express?
The problem I'm facing is that PrintForm has a shoddy quality while getting the printouts and PrintDocument takes way too long to get on receipt printed (Almost 5-10 Seconds!)I'm either looking for an alternative for PrintDocument or somehow make the PrintDocument run faster
Dim
printFont As
New
[code].....
What tools can be suggested to identify how long a group of method's are taking to complete? I have a large math calculation engine that calls multiple classes. I need to track down which ones are the highest cost of time.
View 3 RepliesI have developped a piece of software which needs to load in an XML file stored locally, I do this using the following [code]...
View 1 RepliesStarting a few weeks ago, compiling a project (VB.NET, .NET 2.0, VS 2010) has taken several times as long as before. In Task Manager, I noticed ResXtoResources.exe taking lots of CPU for a while. I've finally been able to get some data on this using MSBuild's 'Diagnostic' output setting, and comparing that output to what I see in a branch from a few months back. Most striking are the final lines, which give timings. Before:
Target Performance Summary:
[..]
1395 ms CoreResGen 1 calls
1930 ms CompileLicxFiles 1 calls
2135 ms GenerateApplicationManifest 1 calls
2844 ms CoreCompile 1 calls[code].....
Both projects were compiled on the same system with the same settings. We've made numerous changes, to be sure, but nothing to the order of magnitude that would justify such a change in timings (and only for this one task!). I assume resource generation is getting stuck on something — a circular reference, a missing one, etc. I have been unable, however, to find anything useful on how to trace such a problem down to what I assume is just a single resource file.Short of looking through thousands of checkins or temporarily removing some forms (and thus, their resource files) from the project, is there anything else I can do to figure out the issue? I can't seem to find individual per-resource file timings.
Findings so far:I've created a new, empty project with all the same .resx files in place.The issue is not reproducible in .NET 4.0: compiling the exact same test project takes less than a second.The issue is reproducible in .NET 2.0 as soon as I also add one of the forms from the original project; apparently, it will otherwise not compile the resources "properly".Removing individual .resx files will reduce the timings 'proportionally'; that is: I have unfortunately not found a single file that is the culprit.
I have the following in my little program:A form containing a button and a combo box where each item is a "year" ex. 2009,2010,2011...
When the user selects an item from the combo box, and clicks a button, an excel spreadsheet is displayed in a datagrid.
- Depending on the item selected, a different file is opened.
Now, my problem is as follows. Every time the user press the button, it takes like 50 seconds to open the file and display it in the datagrid.
- The file range is from A1 to J393 (a lot of cells)
The procedure reads every cell from A1 to J393 and puts it in a multidimensional array. Therefore, I would like to know if there is a way to speed up this process.Another thing, lets say I selected year=2009 and press the button.I wait 50 seconds approx.Displays the spreadsheet (corresponding to the year 2009) on the datagrid.
Then
I select year=2010 and press the button.
Wait another 50 seconds approx.
Displays the spreadsheet (corresponding to the year 2010) on the datagrid.
I hav a web service which pull records from a database and I am hosting these services in IIS which works fine but I am trying to retrieve the record and display the record in a listbox displaying the time field as the text for that record.I have created the following function
public sub get_data()
dim dt as new data.dataTable
dim service as ws webservice.webservice
[code]...
Basically, I have an Access database with Primary keys that are structured with this format ("02"000).When I try to paste the number, it ignores the "02" and goes straight to 000.For example, here is the code;
PeriodRoomID.Name = ("R" & ds.Tables("sqlSpecRoomRequest").Rows(i).Item(1))
What PeriodRoomID.Name should be is R02001.What PeriodRoomID.Name comes up as is R1.It ignores the "02" and ignores the 0s. This makes sense mathematically but it is not what I want. I need a way to get the exact output and not some simplified version.
The query;
SELECT SpecialSoftware.SpecSoftID, SpecialSoftware.RoomID, SpecialSoftwareNames.Description, Rooms.Capacity
FROM SpecialSoftware, SpecialSoftwareNames, Rooms
is there a way to tell if the record is currently open (for editing) by another useregclerk 1 gets recordset for a person. pessimisic lock, client cursor.
View 1 RepliesI am executing stored procedure using ExcuteReader() command. If I execute Stored Procedure in SQL server it is taking 2 secs. But in code taking around 2 mins. I tried DataAdapter.Fill(). Still the same.
What is wrong in the code?
spString = "usp_graph"
sqlcmd_q.Connection = sqlCnn
sqlcmd_q.CommandText = spString
[Code]....
I have List (of class). having 1800 of count and each object has 90 properties. When I terate earch with 90 properties taking more and more time. How to resolve this
Dim cellIntStyle As HSSFCellStyle = hssfworkbook.CreateCellStyle
cellIntStyle.DataFormat = HSSFDataFormat.GetBuiltinFormat("#")
Dim cellDateStyle As HSSFCellStyle = hssfworkbook.CreateCellStyle
[Code]....
below code is taking 150 to 200 second to read data (actualy my response data is very large) [code]
View 1 RepliesSetup taking toomuch time for installation
View 5 RepliesI am using vb.net in which I have put the background image to every form. The image size is 1024X768. When I open the form it is taking too much time to open. and screen is fluctuate.
View 1 RepliesI am trying to update an Oracle Database record and i keep getting this error:
ORA-01704: string literal too long 5
I looked up that error and it seems that i have a limit of 4000 charters since i am using Oracle 10g. However, the prgblem is that its the same exact data i am putting back into that record so that is why i am unsure as to why its giving me that error for the same amount of data i took out of it.
Here is my update code:
Dim myCommand As New OracleCommand()
Dim ra As Integer
Try
[code]....
In the following code I open several Excel workbooks from within the VS 2010 .IDE. I want to Try the open workbook code, then Catch exceptions using a dialogbox as a form created programmatically at run-time. The exception handler works, but the dialog box does not display in front of the workbook. So, the user can't respond to the modal form. If at that point the Excel workbook is shrunk manually to expose the dialogBox which is then dismissed, Excel pops up a "Save Changes?" alert and the VB code does not resume the Sub at the Me.Focus() line
When the workbook Is open Excel is the active application. I think this is why the dialog box is not in front, and I don't know how to solve the problem programmatically.[code]...
I'm going to design an Application (C# or VB.NET) which use .NET Framework to run for very long time. It may be restarted every year or even more...Is there anything (using special design patterns or so) which I must care about in designing "Long time running applications in .NET"?
View 3 RepliesI've been using things like FileOpen, and FilePut for a long time in VB.NET, and it's never presented any problems. However in my latest project I'm using CodeDom to compile at runtime, as you know FileOpen, and things like that are the old VB6 methods, such as MsgBox("Msg"), and these don't work. So I need to know how to do this using only the newer VB.NET code.
[Code]...
I'm looking for the equivalent to a Java System.currentTimeMilli(), in VB.NET.What is the method to call? I know about Datetime.Now, but not about the actual conversion to long milliseconds.More details about my specific need: I need to manage a login expiration. So most likely when I log in, I will set a "expiration_time_milli", equal to the current time + the timeout value. Then later, if I want to check if my login is valid, I will check is "expiration_time_milli" is still superior to current time.
View 4 RepliesI wrote a program which loops through a very long CSV file (50 meg) and parses the data as it goes.Sometimes, the program aborts and I get the following message:The CLR has been unable to transition from COM context 0x37a090 to COM context 0x37a200 for 60 seconds. The thread that owns the destination context/apartment is most likely either doing a non pumping wait or processing a very long running operation without pumping Windows messages. This situation generally has a negative performance impact and may even lead to the application becoming non responsive or memory usage accumulating continually over time. To avoid this problem, all single threaded apartment (STA) threads should use pumping wait primitives (such as CoWaitForMultipleHandles) and routinely pump messages during long running operations.
I know its going to take a while. There are several hundred thousand lines of text in the file that this program is reading. I am not sure exacly waht the message means, but my program seems to work fine other than the message. odd thing is sometimes the message doesnt always pop up..
I've a solution with 15 projects (14 class libraries and one web application). Each class library has corresponding test project (i.e. if I have MyApp.Services project there exists MyApp.Services.Tests -- using NUnit). Everything is written in VB.NET. The problem is that when VS tries to compile any of *.Tests project it stops responding (the bigger the project the longer the period without reposnse). I don't know where to start looking for an issue. I'll add that I've R# 4.5 installed.
UPDATE 1:Is there any way to benchmark a build in visual studio? To get build times for every project?
UPDATE 2:It seems that there is no difference after disabling R#.
Occasionally, my website will stop functioning and anytime an ASP page is accessed, the browser will hang for many minutes before bringing up a correctly formatted HTML page with nothing in the tag. It seems to happen whenever more than one person attempts to access an ASP page, but I'm not positive it's isolated to those conditions.
Let me emphasize that the issue does not arise when accessing directories/HTML pages/other files. Only ASP pages are the problem. I am using lunarpages as a host.
I have a problem with my (aspx.vb, aspx) program. Since my vb program require more than a day to make some data analysis. however, the page always run a long period(one hours exactly) will be downed and become cant display the page. i am wondering is it related to dns error?
View 3 RepliesActually, I am trying to find out whether the partno is existing in the database table or not and it takes long time in count = checkCommand.ExecuteReader statement
Public Function CheckProductNo(ByVal Partno As String) As Boolean
Dim count As SqlDataReader
Dim valid As Boolean = False
Using connection As New SqlConnection
[code]....
I'm trying to time how long an operation takes in Visual Basic (VS 2008) but its not working. the code I have is as follows:
[code]...
this is in an OnClick event, so what happens is that the user can click a menu item, and it goes and sends any changes it has to a database, and pulls down any new changes to a local data cache. This operation takes time, depending on how many changes are on the server and how many are cached locally. I've thought about making this a background task, so it doesn't draw away from the main app while it's running, but before doing that, I'd like to get an idea how long the operation takes. Since I can't exactly do a progress bar, I figured using the stopwatch would tell me how many ticks/milliseconds would occur between click, and when the "total synced" message comes up, but every time i run it and do an update the message always shows 0 ticks/ms. I don't think it's accounting for the delay, just from start to finish. Is there any way to make it so it detects a message popping up and times off that?
I need to find the best solution to count how long it takes to make a request to database like connect, do a select and receive the answer. And if that take more than 300 milliseconds I must cut the connection.
Public Function FindLastCt() As Decimal
FindLastCt= 0
Dim strrequete As String = "SELECT MAX(CM_Codigo) FROM CAJITAS WHERE CM_Date >= '" & Format(DateTime.Now, "dd/MM/yyyy") & " 00:00:00.000' AND CM_Date <=
'" & Format(DateTime.Now, "dd/MM/yyyy") & " 23:59:59.999'"
Using connection As DbConnection = factory.CreateConnection()
[Code] .....
I'm trying to make a macro for a game, so I use long spells in a shorter amount of time. I'm having trouble with a lot of things. For starters I get the when I start the programs timer: "A call to PInvoke function". (I'm calling it a hack, but it's not a hack because it doesn't hook into memory addresses, only sends keys when the correct combo are pressed)
Option Strict On
Public Class Form1
Private Property hEnabled As Boolean
Private Declare Function GetAsyncKeyState Lib "user32" (ByVal vkey As Long) As IntegerPrivate Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
If (hEnabled = False) Then
[Code] .....