I need to provide management with proof that a group of existing stored procedures that use cursors are the cause of much of our performance issues. Can someone point me in the right direction to find scripts and queries to accomplish this, please? Such as, how to monitor and measure cursors, etc. Using SQL Server 2005. Thanks. ====...
I have a MySQL database that I'm porting to PostgreSQL (because of GIS features). Many of the tables have hundreds of thousands of rows, so I need to keep performance in mind. My problem is that PostgreSQL seems abysmally slow... For example, if I do a simple SELECT * FROM [table] on a particular table in the MySQL database, let's say...
Hi I refer to the following article, http://www.codeproject.com/KB/aspnet/paging%5Fwith%5Furl%5Frouting.aspx 1) Would like to know whether it avoids full fetch of data? To gain the performance as it mentioned in the stackover flow question here? http://stackoverflow.com/questions/1061574/custom-paging-or-standard-paging-in-asp-net-wh...
I've a MySQL InnoDB table with 1,000,000 records. Is this too much? Or databases can handle this and more? I ask because I noticed that some queries (for example, getting the last row from a table) are slower (seconds) in the table with 1 millon rows than in one with 100. ...
What would be the best way to show the contents of a large text file to the user using Winforms? Right now I've tried a multiline Textbox, but this is rather slow for a 2MB file. ...
I am noticing a large performance difference between Java & JOGL and C# & Tao.OpenGL when both loading PNGs from storage into memory, and when loading that BufferedImage (java) or Bitmap (C# - both are PNGs on hard drive) 'into' OpenGL. This difference is quite large, so I assumed I was doing something wrong, however after quite a lot o...
I'm using WindowsTokenRoleProvider to determine Active Directory group membership in an ASP.NET web application. My problem is that performance is not good, especially when a user is in many groups. As an example, I am in 253(!) groups, and WindowsTokenRoleProvider is taking around 150 seconds to determine what groups I am in. I know I...
My current dilemma is as follows: I have a 2550x3300 tiff. At certain (variable) points in my tiff I need to insert a line of pixels from elsewhere in the tiff. e.g. I need to insert 12 copies in a row of line 100 between lines 500 and 501. I've been looking up different image processing techniques for a few days now and can't find any...
Hello. I read an article about the performance of the string methods "a" + b versus string.Format("a{1}", b) and decided to make a test. There is my code in a WinForms application(VS 2005, but interested in both 2005/2008). private void button1_Click(object sender, EventArgs e) { Stopwatch stopwatch = new Stopwatch(); ...
I have tried two different implementations for simulating POSTing a form. One uses fsockopen (example here: http://www.faqts.com/knowledge_base/view.phtml/aid/7962) and the other uses fopen (example here: http://netevil.org/blog/2006/nov/http-post-from-php-without-curl). I ran into some serious performance problems with fsockopen - whe...
(EDIT: rewritten question to make it clearer, meaning hasn't changed) You can create an application and measure its usage. But what I would like to know, if you decide up-front about an ASP.NET application, how much simultaneous users (sessions) fit into one machine typically. Let's assume the following default simplified setup: Inpro...
hoping someone has experience with both sql server and postgresql. Between the two db's, which one is easier to scale? Is creating a read only db that mirrors the main db easier/harder than sql server? Seeing as sql server can get $$, I really want to look into postgresql. Also, are the db access libraries written well for an asp.net ...
Recently I found out that there are several things that one can do to massivly slowing down a Flex application. One of those things is the use of many nested layout containers. Another thing which is very problematic is the usage of lot's of relative positioning and sizes. I do understand that there is a very big amount of calculations ...
I have a PHP page that gets its content by making an HTTP request to another site on the same server, using file_get_contents. Both sites run in Apache 2 which calls PHP using suPHP (which is FastCGI, right?) How significant is the overhead of this call? Does Apache do a lot of processing before sending a request to PHP? An alternative...
Hey all, I am just wondering if there is a significant performance decrease to serving files from separate directories. Please don't comment asking why I want to do this.. short answer: MVC framework. But would this be a big deal performance-wise? Ex. Main/index.php Create/index.php View/index.php etc... Thanks, Matt ...
I am developing Ruby application with Netbeans because of its automatic code completion and its inline help system. But when Netbeans try to autocomplete the source code while typing, the typing looks like stopped. Is there any way to improve this experience? Maybe by disabling the code completion, inline help system, syntax highligh...
Hi, I wrote tcl script as an glue between different apps which are computationally intensive. When I run top command I see that 2 cpu's are 100% utilized. The one is for the tcl and the second is for the application I am running. The question is: why the tcl is utilizing fully one of the processors when the binary application is heavil...
would i get any performance gains if i replace my data access part of the application from nhiberate to straight ado.net ? i know that NHibernate uses ado.net at its core ! ...
In analyzing Java GC behavior, some tools has the metric "garbage collection rate" (an example would be in figure 19. from http://www.ibm.com/developerworks/java/library/j-ibmtools2/#fig19) of which the unit is MB/sec. It's a rarely metric compared to others, like GC utilization. It looks like representing how fast GC cleans up. But doe...
What are the Linux equivalent of Windows's performance counters? API/libraries to publish application counters API/libraries to monitor and collect values efficiently (like pdh.dll) applications to monitor the current values (equivalent of perfmon.exe) applications to schedule collecting (like logman.exec) applications to visualize co...