i have simple table with two fields: ID and Date how can i do Select that will return true or false, of course without Scalar-valued Functions it must be something like that: SELECT (Date < getdate()) as mu_value FROM my_table ...
In my ASP.NET app, I have a dictionary that contains a large number of objects (let's say as large as 1M, could get even bigger later), the object stored in the dictionary is of reference type not struct type, the dictionary is meant to work as a cache for this type of objects (I have my reasons not to use the ASP.NET cache for caching t...
I wrote some code in C and I was surprised to see it take a longer time to execute than I expected. I want to know which operations are costly and how to get rid of them. I use assignment statements, conditional(nested), loops, function calls and call backs. What are some good references to common C performance pitfalls? Is there a ...
Tinkering with Performance Monitor, I see: Web Service -> Current Connections Web Service -> Get Requests/sec Are there better counters to look at? Or perhaps other software? Thanks, -E ...
I'm talking about things like page/stylesheet caching, minifying javascript, etc. Half of me thinks it's better to do these things as early as possible while still in development so I can be consciously aware of more realistic speed and response issues as well as interacting with something that more closely resembles what will be deploy...
Do you know how expensive exception throwing and handling in java is? We had several discussions about the real cost of exceptions in our team. Some avoid them as often as possible, some say the loss of performance by using exceptions is overrated. Today I found the following piece of code in our software: private void doSomething() {...
I am reading each line of a CSV file and need to get the individual values in each column. So right now I am just using: values = line.Split(delimiter); where line is the a string that holds the values that are seperated by the delimiter. Measuring the performance of my ReadNextRow method I noticed that it spends 66% on String.Split,...
Hello. I have main php-file with main class. Also in this class i do require_once("func.php"); which has many useful functions for my site. Size of func.php is very big, because there is many functions for different actions on different pages. But I include it on every page, because including called by main class. What I need to d...
I am using the TCP/IP Adapter for BizTalk Server 2006 which was obtained from codeplex: http://www.codeplex.com/BTSTCPIP Once the application was deployed in production, we started to experience choking in the performance of the application. The more the requests, the more the performance degradation. Sometimes, it happens that the rec...
We currently have a system where each client gets their own database when they sign-up. Not surprisingly this is getting out of hand. We are preparing merge all these databases together to a single db. In order to do this we need to note which organization the row belongs. How best is this handled on the database and what pros/cons (...
I have a window using a WPF ListView/GridView bound to an ObservableCollection. The performance is utterly horrific. The application chokes trying to load 300-400 items and CPU usage spikes each time an item is added/removed/modified. Profiling doesn't reveal anything obvious. Anyone have any suggestions? ...
I have a C# service written for .NET 2.0 that uses the Oracle data access provider for .NET 2.102.2.20. The service runs multiple threads and runs lots of queries to an Oracle 9.2 database. I am using NHibernate. What I am seeing is that when it starts up it runs fast, then gets slower and slower. The CPU usage starts low then goes up a...
I have an application in Grails. I use Hibernate to access the database (per standard grails rules) I use MySql and the site works and is stable (for 6 months). I am doing load testing, and recently discovered that the database rejects connections when under load. Using MySQL Server 5, I can see threads connected hovering around 20. Th...
I can't seem to get acceptable performance from FullText Catalogs. We have situations where we must run 100k+ queries as quickly as possible. Some of the queries use FREETEXT some don't. Here's an example of a query IF EXISTS(select 1 from user_data d where d.userid=@userid and FREETEXT(*, @activities) SET @match=1 This can take bet...
We have a huge (old legacy java) code-base, where many files (around 5k) have System.out.println's. We are planning to remove them for cleanup/performance reasons. How can we write a script that will replace them without introducing any issues in the code? The script cannot blindly delete them as following case can be an issue: if () ...
Hi, Microsoft make this piece of software called "Visual Studio 2008 Professional". I have found that there doesn't appear to be an application performance profiler or something similar in it, making it seem not so "professional" to me. If Microsoft don't include a profiler, what are your third party options for time profiling for Visu...
I am working on a Drupal based site and notice there are a lot of seperate CSS and js files. Wading though some of the code I can also see quite a few cases where many queries are used too. What techniques have you tried to improve the performance of Drupal and what modules (if any) do you use to improve the performance of Drupal 'out o...
In java, im creating a SortedSet from a list which is always going to be ordered (but is only of type ArrayList). I figure adding them one by one is going to have pretty poor performance (in the case for example of an AVL tree), as it will have to reorder the tree a lot. my question is, how should i be creating this set? in a way that ...
One of the stated reasons for knowing assembler is that, on occasion, it can be employed to write code that will be more performant than writing that code in a higher-level language, C in particular. However, I've also heard it stated many times that although that's not entirely false, the cases where assembler can actually be used to g...
What are the best practices for optimizing a MySQL installation for best performance when handling somewhat larger tables (> 50k records with a total of around 100MB per table)? We are currently looking into rewriting DelphiFeeds.com (a news site for the Delphi programming community) and noticed that simple Update statements can take up ...