VS 2010 Getting Started With Linq, Code Is Very Slow?
Oct 19, 2011
I am using DataSet.ReadXml() to create a DataSet from the following XML file, so that I can quickly query it using Linq.[URL]..I then use the following object to create a DataTable which can be used as a dictionary, with a ConvertToFriendlyFormat function that takes an Emulator_Id and and a string that corresponds to a DicEntry node's StoredFormat attributed, and return the same node's FriendlyFormat attribute.
This does work BUT it is extremely slow (~11 seconds to call it ~220 times). I have been unable to figure out how create the DataSet when the object is initialised and just query the simple DataTable in the ConvertToFriendlyFormat call. I guess this is what is slowing it down?
I've tried using the VS 2010 beta to edit some real projects, and it is next to unusable due to performance issues. The cpu is more or less constantly at 100%, and most often the code editor uses around 10 seconds to respond to any text input. If I introduce a couple of compile errors things get even worse. Are there some drastical performance improvements that are planned in the VB editor before release, or are there special things that might trigger this?
I'm using LINQ to SQL to query some data.Here's my Employees table colummns:
-FirstName (or givename i.e. John) -LastName (has middle name and family name seperated by space i.e. Mac Tenny
Some people have middle name and some don't. Here's some sample data.
-FirstName LastName John Mac Tenny (with middle name "Mac") Mike Mika (no middle name)
[code]....
I want to query for people who have their middle or last name started with search criteria. Here's how I search for employees with middle name started with "joe" :
query = From emp In db.Employees _ Where emp.LastName.StartsWith("joe") _ Select emp
How do I query for employees with family name(last part of the LastName) started with "joe"?
I'm developing a piece of a system that basically migrates data from one set of tables to another set. Everything works fine, but I've decided to employ transactions instead of just failing on things that are partially completed. (That is, if some exception occurs, I want to rollback instead of having partial data migrated.)
I have a service (in the 3-tier architecture way, not web) which begins a transaction on the data access layer. The data context is shared in the data access class which contains many methods. Those methods use various LINQ-to-SQL techniques to update/insert/delete. All the LINQ-to-SQL "selects" are within CompiledQueries. [code]...
Is there any particular reason why creating a reference to an object in an IEnumerable Linq query would be really slow? I have a Linq query list consisting of my own objects (count is about 200).I was doing a time-critical task, and this line (which was used a lot in a loop) took nearly a millisecond to execute:
I want to know if there is a way where i can view the code that my computer sending threw the cpu so i can learn it is there a program i need to so this
This is my first post..and it is a question. Hope some day I will be able to provide also answers... I started a third-party external application using Process.Start function. Does anybody know how I can code a click of a certain button in that application (the name of which I know)?
well until a few day ago. I don't know what I have introduced to cause the problem but now, whenever I load the project, VS 2010 (SP1) crahes. If I delete the project's suo file, the project loads (really quickly) and all is well until I exitVS 2010. When I re-run it and try to load the project, it crashes again unless I delete the suo file.The program can be built for x64 and x86. Now, when I reload the project (after deleting the suo file), it comes up in Debug - Any CPU mode. I can change from Debug to Release and from Any CPU to x86 but if I try and change from x86 to x64, VS 2010 crashes.This is not always the case though. If I build the x86 version and then switch to x64, all is well and I can build the x64 version. Obviously, there's something wonky going on.
i was trying to make a free microsoft word plugin in vb.net. It automatically fills a web form. The main problem with the plugin is that it uses web browser control and once it has filled a form it will need to navigate another form. The form can only be filled once it has completely been loaded.so my approach is
1. navigate to first site when form loads
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load WebBrowser1.Navigate("http://google.com") End Sub
2. use an integer i and use if statements to check which form to fill :
Private Sub WebBrowser1_DocumentCompleted(ByVal sender As System.Object, ByVal e As System.Windows.Forms.WebBrowserDocumentCompletedEv entArgs) Handles WebBrowser1.DocumentCompleted If (i = 1) Then[code].....
3. this is the main step. you see when main form loads, i=1 so browser goes to google.com (first form), when form is completely loaded, itchecks for value of i. Since i=1, it fills google. After filling and continuing i=2 and browser goes to my personal account page. This means browser again loads the document. Now i=2, so it fills my personal detalis. Now the timer starts. Since i=3, browser navigates to second site and fills the details.
Private Sub Timer1_Tick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Timer1.Tick If (i = 3) Then WebBrowser1.Navigate("http://blogger.com")[code]...
now the problem arises. The browser does not go to the third site. Once the timer has been stopped and started, the following code does not goto the elseif part (i.e. i=5) why is that so?
I just upgraded a project from VB 2008 to VB 2010. Before, the project did not use LINQ. I have started implementing it. So, I have updated the target framework from 2.0 to 3.5, and added a reference to System.Core, and imported the namespace System.LINQ to the entire project and also imported System.Data.LINQ into the form I'm working with (because it was not available in the list for Imported Namespaces in the references tab).
It's not throwing any errors now, but my IntelliSense is not working for LINQ stuff.
For example... I write this:
[CODE]....................
Then, if I type S. on the next line, the IntelliSense doesn't grab what it should for S (Only get Equals, GetHashCode, GetType, ReferenceEquals, and ToString, instead of the options I should get like Count, First, FirstOrDefault, etc...). If I Type S.First. then its the same thing, no IntelliSense that lists the available fields for S, just the standard options (Equals, GetHashCode, GetType, ReferenceEquals, and ToString). I should be seeing my column names in my table when I type S.FirstOrDefault.
So any ideas what is going on? When I type the code, for example, MessageBox.Show(S.FirstOrDefault.FirstName), it works perfectly. But it doesn't change the casing of the text (so it would read s.firstordefault.firstname) and no intellisense while doing it. But no errors. BTW - Everything works perfectly when creating a NEW VS 2010 application, it's just my projects upgraded from Visual Basic 2008 that have this issue.
Does anyone started to work with VB 2010?. I have to migrate an application from VB6 to a new language and I've decided that I will rewrite the application on VB 2010. Well, I am here in front of the new flash 2010 and I have no idea where start. ja!
I've got a vb.net 2005 form that calls a stored proc to load a combobox with eligible sales reps. There are approximately 40k sales reps available...I know that's a lot, but that's what I'm dealing with. I'm trying to figure out why it's taking this form 15 seconds to load.
Here's my code:
Want to load this in the most efficient way possible given the HUGE amount of data that my client is wanting to see.
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Hide() Dim value As String = """" + Application.ExecutablePath + """ -nogui"
[code]....
I want the program to exit the sub after the timer has been started. But if theres no args, it should just show itself. The problem is that it seems to not care about the exit sub thingy, cause it shows itself anyway.
how to use Visual Basic to pass arguments to an application after said application was started. Example, "myapp.exe -d" enables debug mode, I want to be able to start myapp.exe then have a checkbox labeled "Debug mode" in Visual Basic. Upon "Debug Mode" being checked, it passes the argument -d to myapp.exe. Upon it being unchecked, it withdraws that argument from myapp.exe.
I noticed that my application is running a bit slow. This is a Windows Service built using VB2010 with SQL Server as a back end. Its main function is to poll a folder looking for a text file. If found it reads the text file and imports the data into SQL Server.
While the slowness could be caused by a number of reasons, I am looking at my code to determine if it could be more efficient. Below I've pasted snippets of code where I initialize the DB connection and execute SQL statements. I've also included a snippet that illustrates how I am processing the text file.
I'd appreciate if the group could have a look at these and let me know if the method that I am using is the most efficient possible. At this time I am also focusing on other probable issues, but I can't rule out the possibility that the code that is in place might be a contributing factor.
I have written a quick 'algorithm' that automatically formats curly brace code in the correct way:[code]It works quite simple, it loops through all the lines and keeps track of the brace count using a counter. The counter will be incremented by 1 if it finds an opening brace, and decremented by 1 if it finds a closing brace.Then, each line is trimmed, and a total of "n" tabs is inserted before the text, where "n" is the brace count as explained above.[code]So my question basically is, how can I avoid having to do the same thing (exchanging lines) twice? I have noticed that the actual exchanging of lines is very slow, so having to do it twice for each closing brace line is simply a very bad design..
its' only me, or is VS2010 really so slooow? This taking 50 seconds to open vs2010, 30 seconds to change from an small project to other small project.as a comparation, in the same machine I can open three different vb6 projects, each one in one different vb6 instance and each one takes "only" three to five seconds. of course I can maintain all the three instances opened all the day, sutching from one to other, debugging, changing, even generatin' exe files, without noticeable penalties.machine is Dell Vostro 1700 4 GB, two internal disks, Win Vista business, Intel Core 2 Duo T 7500 2,2 GHz. two years old.
I have created an app, that reads data from a .txt file, and compares it to data retrieved from a website. The only problem is that my program slows down and sometimes even freezes at specific points in the program. I don't understand why, because that specific point in the .txt file is no different then the rest of the file.
Here is my
Function vertaalGegevens(ByVal teller) Dim webStream As Stream Dim webResponse = "" Dim req As HttpWebRequest
[code]....
I also tried making a different thread, but that became way to complex for this simple program.The text file i import is 1.5 mb big, and contains aproximatly 66,000 records that need to be run trough. These records are contained in a ArrayList. The word "teller" in the code stands for count, this value gets higher each loop. The loop is run outside this peace of code.I was thinking that maybe I didn't close the webresponse object, so I also tried webResponse.Dispose(), with no success.
I have been using VS2010 without any issues, always on the same application. Suddenly within the last my solution has become unbearably slow when right clicking. When doing other projects, it is fine. The only thing I can think of that I changed was disabling the SQL Server debugging.It happens if I right click anywhere within the code editor. Everything freezes for about a minute and a half, then the right click menu shows up. Intellisense seems to work fine. It is only the right click.The project is fairly big, but it has been working fine. I am working on a 2 month old top of the line MacBook Pro (running Windows 7 64 bit in Boot Camp). I did do the patch Tuesday big batch of Microsoft patches in the last 24 hours...
I have a number of FTP routines all based on the code below. Why does this take 15 seconds to run the first time? [Code] If I use an FTP program like FileZilla or CuteFTP to connect to the same FTP server they make a very much quicker connection. Any ideas?
am new here. am using vb2010. I have a form with 3 panel. each panel have 10buttons. when click on button 1 from panel 1, it will show panel 2. Then on panel 2, when cancel button is click, it will go back to panel 1. My problem is, when go back to panel 1, all the buttons in panel 1 shows very slow. It shows one button after another.
I`m trying to write a small program which connects to a serial port at 115kbps and reads a stream of continuous bytes from a microcontroller. The program should then graph these bytes by time. Ideally this all happens in "real time" and as quickly as they can be sent.With a 50ms serial write delay on the micro the VB program keeps up fine, but if I lower the delay any further, say down to 1ms, the update can`t keep up and the serial buffer just grows.I wasn`t expecting the bottleneck to be the PC side so it`s likely my code is doing something wasteful. Or maybe it`s the graphics which are drawing slow?
Private Sub DrawGraph() Try Dim y As Integer = m_Y Do
I have a text file I'm trying to pull specific data from to make a report in excel and am wanting to know if my code can be improved or if I have something wrong. If it's apparent to anyone that I should be doing something elThis code does work but, very slow. These reports take up to 20 minutes for about 100 files so I am wanting to decrease the time somehow. I have attached the whole sub in a text file, it's about 900 lines long so don't think I should post all of it. This is one part that seems to take the longest:Partial code that reads the text into a string, then each line is read to find whether it holds the data or not. Inside this while loop, I am checking numerous lines to see what they hold and extract specific items. First I verify it's a interface by checking for "line protocol".
Dim str As StreamReader = File.OpenText(filefound) While (str.Peek <> -1) If txtLine.Contains("line protocol") = True Then 'Found an interface,
I'm making a program that will print jpeg's.The way i have it is I have lots of forms with buttons and when you click a button it prints the photo and a databound label with a line of text.The problem is that i want the user to be able to click one and then click another button right after, to print another one, but as soon as i click one, the program freezes until the photo starts printing so the user cant click to print another one right away.Each picture is around 4 mb.Is there away to make it go faster?The pictures i'm printing are from a pdf file with text and images in it that were converted to jpg. Each page is another jpg. Is it possible to print directly from the pdf and would it be faster since the words are 'text' and not a 'photo'?
I'm trying to write this as LINQ, [code]I'm a LINQ beginner, so far I'm not quite sure where to use and where not to. If in this case LINQ will do more harm then help, feel free to flame me.You can assume that there is an overload for AddLink() which takes IEnumerable
I only want to return a certain number of rows into the DataTable via LINQ's Take or use it on the Rows property, but I am not sure how or where to do it: Here is the current code:
Dim dt As DataTable = GetDataTable("sp", params) For Each dr As DataRow In dt.Rows Dim o As New OR()
