| Best Practice, Performance? - Several User Controls on page opening database connection (4 replies) |
| microsoft.public.dotnet.framework.performance |
| I have a following problem. I have several User Controls (*.ascx) and each of them retrieves some data from database (Headlines, Top 10 of something, Events Today, Current Users etc). Each of them opens DB, displays data, saves the data to cache for later retrieving (for 5 60mins) and closes DB connection. But it seems inefficient to open and close connection for each user control (if they are all... |
|
| Slow response from ASPNET_WP.exe (4 replies) |
| microsoft.public.dotnet.framework.performance |
| Happy New Year We are having issues on our ASPX.net web server. The ASPNet WP.exe is very slow to respond to requests. Attached is an image showing the trace information from both our live web server and our beta testing server and the code. As you will see there is at least a 15 sec difference between the two in the "BindJobsData DataSet". I'm curious as to what factors would influence this respo... |
|
| Debug.WriteLine overhead? (2 replies) |
| microsoft.public.dotnet.framework.performance |
| Hello All. Is there a rule of thumb that indicates the amount of overhead using System.Diagnostics.Debug.WriteLine may introduce? Does the overhead depend on the 'consumer' ie. DebugView from SysInternals (say)? I know that this is not a welldefined question as the string to be written may be arbitrarily expensive to compute. However, let's assume a string literal is to be written. Regards, Thomas... |
|
| scalability issue when loading xml file in a web service (3 replies, VIP) |
| microsoft.public.dotnet.framework.performance |
| In my web service I need to load a XML file for reading in every request. I don't want to cache it in memory and so each new request to the web service requires loading of this file. I am using XmlDocument.Load() to load the file. Under heavy load, this API throws an exception complaining not able to load the file. I am suspecting the XmlDocument.Load() place a exclusive lock on the file and forbi... |
|
| SqlConnection.Open() Performance? (5 replies) |
| microsoft.public.dotnet.framework.performance |
| Hi, I am a little frustrated with the overhead involved in opening a System.Data.SqlClient.SqlConnection. In a distributed computing environment, developers are encouraged to obtain and release database connections quickly (with emphasis on the release). My tests show that when using Integrated Security, even connection pooling connections, when using Integrated Security opening a connection serio... |
|
| Complex Dataset as Grid Datasource? (3 replies) |
| microsoft.public.dotnet.framework.performance |
| When populating a grid, what I've done in the past was to call a stored procedure that joined several tables into one resultset, retrieve that into a datatable and set the datatable to be the datasource for the grid. Now what I'm looking into the feasibility of, is NOT doing the joins in the SP, pulling down some data from the individual tables in the database into matching datatables in the datas... |
|
| WithEvents By Default ... Performance Problem? (3 replies) |
| microsoft.public.dotnet.framework.performance |
| Does the fact that all WinForm objects are declared as WithEvents by default affect performance? I have made it a habit to go back and remove the WithEvents from my objects, leaving it only when necessary. Unfortunatly, this gets tedious when it gets added back to every new object I put on a form. I know that using AddHandler as opposed to WithEvents is supposed to be more efficient, so wouldn't t... |
|
| Safe vs unsafe (8 replies) |
| microsoft.public.dotnet.framework.performance |
| Hi, I'm making a very simple test on reversing a string in C# in a standard manner (with Array) and with unsafe code. Well, the constraint I setted is to have two methods with the same signature in order to mantain the same black box conditions. The standard way I used is: public void Reverse(ref string a) { char[] array a.ToCharArray(); Array.Reverse(array); a new string(array); } This solution p... |
|
| how to get the role/group that a particular login belongs to? (6 replies) |
| microsoft.public.dotnet.framework.performance |
| By using string name SystemInfomration.UserName; or WindowsIdentity MyIdentity WindowsIdentity.GetCurrent(); WindowsPrincipal MyPrincipal new WindowsPrincipal(MyIdentity); string name myIdentity.Name; But how can I get the role/group that the user belong to? e.g. Administrator, power user I know that there is a method to check the role, but only limited to windows pre defined roles. MyPrincipal.Is... |
|
| Best way to update a table. (4 replies) |
| microsoft.public.dotnet.framework.performance |
| Hello, I need to update a DB table with a large list of information. For each element in the list I need to find the approriate record in the table and update it. I am using a DataAdapter to fill a DataSet with the table data, and then finding and updating the DataRow and then updating the DataAdapter at the end. This is slow. What is the best way to find a DataRow in a DataTable (I do not know th... |
|
| Timers vs. While Loops (6 replies) |
| microsoft.public.dotnet.framework.performance |
| I am interested in knowing WHY a Timer is or is not better than a While loop. What are the PROS and CONS of each one of them. ie.. Is one of them more memory, processor intensive ? etc... ThanX for the help Christopher Roberts |
|
| Source Code "Performance Test": C++, C#, VB.NET, Java, ... (13 replies) |
| microsoft.public.dotnet.framework.performance |
| Language: C#, VB.NET, Java, C , Pascal, ... S.O: Windows, Linux, Dos AVAIABLE SOURCE CODE Performance Test: http://www.alessandropulvirenti.it/programmazione/ bye bye Alessandro Pulvirenti alex@alessandropulvirenti.it http://www.alessandropulvirenti.it |
|
| SAD but TRUE (10 replies) |
| microsoft.public.dotnet.framework.performance |
| VB.NET is much slower when connecting to databases than VB6.0. Here are the results for VB.NET Class library (DLL) that connects to SQL Server 2000 database via OleDB and SQLClient: OleDB: 80ms SQLClient: 180ms NOTE! VB6.0 COM Component running under MTS and connects via Ado2.7: 10ms Conclusion: VB6.0 is much faster than VB.NET or there is something wrong in my VB.NET DLL configuration or in VB.NE... |
|
| DateTime performance (3 replies) |
| microsoft.public.dotnet.framework.performance |
| hi, The .net framework works in very high performance, it beat down the win32 applications , but the DateTime class is much slower then win32, perhaps it have more precision than double(many win32 language & database using double to implement datetime), but it's no use in many case. hope microsoft can improve the datetime performance by implement it in double, and implement high precision in anoth... |
|
| Caching not possible in WinForms!?!?! (6 replies) |
| microsoft.public.dotnet.framework.performance |
| Hi, You're the last resort here; I have a big Windows application that processes a large amount of data. Biggest of the tables contains over 2,5 mil recs. For some reason, users want to have an option to see all the data at once also(like "select * from tbl"). All of the reasoning to them led to nothing. They want to be able to see over 2 mil rows in the DataGrid. Now, here comes the intresting pa... |
|
