performance-tuning

What are the most important optimizing performance best practices in C#

Hi When I'm reading this tutorial I noticed the following performance tip about using structs in C#: Unless you need reference type semantics, a class that is smaller than 16 bytes may be more efficiently handled by the system as a struct. I looked for similar question in stackoverflow but I found some questions that talks a...

How to determine bottlenecks in code, besides visual inspection?

When visual inspection fails, how do you determine where the slowest points in your code are? Where are the bottlenecks that are ruining your runtime? ...

Uncompressing content in browser on client side

Hi I am interested to know about the possibilities of reducing http requests on servers by sending different kind of contents in a single compressed files and later uncompress on client's browser and place the stuff(images,css,js) where it should be. I read somewhere that firefox is working on plan to give such features in future relea...

Please help identify MySQL performance bottlenecks in my app

I have a facebook app that I have written in PHP/MYSQL and FBJS/AJAX. The app is Rails Across Europe, which may be found at http://apps.facebook.com/rails_across_europe (please note that it does require access to your FB data). If you would like to view a screencast of the app's operation, you may do so at http://screenr.com/TZR and http...

Sql server 2008 - performance tuning features for insert large amount of data.

Hi, I have to insert large amount of data into a table. Does sqlserver 2008(compared to 2005) has any new features to increase the performance in this case ? ...

.gvs (GuideView openmp statictics) file format

Hi Is there a format of *.gvs files, used by GuideView OpenMP performance analyser? The "guide.gvs" is generated, f.e. by intel's OpenMP'ed programmes with $ export LD_PRELOAD=<path_to_icc_or_redist>/lib/libiompprof5.so $ ./openmp_parallelized_prog $ ls -l guide.gvs ...

Query Runs fast, but runs slow in Stored proc

I am doing some tests using the SQL 2005 profiler. I have a stored procedure which simply runs one SQL query. When I run the stored procedure, it takes a long time and performs 800,000 disk reads. When I run the same query separate to the stored procedure, it does 14,000 disk reads. I found that if I run the same query with OPTION(re...

New Relic v/s Yourkit for profiling and testing

Hello People, Which is better for profiling between Yourkit and New Relic(as only these two options are provided by management) for our web application, which is developed using the following :- JDK 1.5 Struts 1.3 (with tiles 1.3) EJB 3.0 Oracle 9i Velocity (for email templates) Oracle 10g WebServices (JDK 1.6) considering their pro...

High Number of MySQL Temporary Disk Tables

Hi, We have noticed that MySQL is reporting a very high number of temporary disk tables (over 10,000) this is reported by Server Density. Were trying to understand a bit more about this. Why are temporary disk tables created by MySQL? What impact do they have on performance? Are they ever removed by MySQL or will this number just inc...

SQL Statistics and Indexes - How detailed are they?

Do the statistics (which help decide whether an index is to be used) take into account the number of rows per actual column value, or does it just use the average number of rows per value. Suppose I have a table with an bit column called active which has a million of rows, but with 99.99% set to false. If I have an index on this column,...

Parallel data loading to increase site performance

I have been reading Steve Souders and others and blogs about increase site performance. My previous question about introducing Queues was also part of it to increase my site performance. Apart from header compression,CSS/JS minifying and their positions, one thing I read about loading resources from different subdomains. One of the exam...

Test database to test performance tuning techniques in Oracle

Hello gurus, I want to test some performance tuning techniques on a realistic database with many database tables and a lot of data. I would like to do this in Oracle 11g Release 1 and would like to know how best to go about this or if there is a website I could get realistic datasets/database from. Many thanks for your audience. Cheer...

SQL Sorting: server vs. client

Most of the times, when it comes to sort some data, we have two options: Sort on the SQL server -- use ORDER BY clause Sort on client one we get the data from the database When would you use one over the other and why? ...

what is the fastest way to update thousands rows in mysql

lets assume you have a table with 1M rows and growing ... every five minutes of every day you run a python programm which have to update some fields of 50K rows my question is: what is the fastest way to do the work? runs those updates in loop and after last one is executed than fire up a cursor commit? or generate file and than ru...

troubleshooting a PHP captcha script that fails to render the complete random string...

I'm using a captcha script for a form. Strangely the image will frequently fail to render the first character of the string of random characters. This pattern will last for about 8-12 refreshed pages, before the expected behavior is reestablished. I know the string contains the full set of four characters because I've debugged this wit...

Performance Tweaks for a Windows Console Application

I have a windows console application that queries a single database and creates flat files of the data for another external system. I will use Task Scheduler to execute a batch that will start this data export. Each query is retrieving a few hundred thousand rows of data (200k+). What is the best way to make my application scalable so th...

sql query takes much long time compared to next run

Hi, I'm running a procedure which takes around 1 minute for the first time execution but for the next time it reduces to around 9-10 seconds. And after some time again it takes around 1 minute. My procedure is working with single table which is having 6 non clustered and 1 clustered indexes and unique id column is uniqueidentifier data...

Squeezing just a little more performance out of Core Animation

I have a game that's moving fewer than 10 small animated UIImageViews at once, maximum. I'm driving their animation with a CADisplay timer running at 60fps. Here is an example of how I move the views in my update method: // for each insect in insectArray insectView.center = insect.hitCenter // I pull a position from my model object Th...

fit mysql db in memory

I am using Redis database where we store the navigational information. These data must be persistent and should be fetched faster. I don't have more than 200 MB data in this data set. I face problem when writing admin modules for redis db and I really missing the sql schema and power of django style admin modules. Now I am thinking of ...