I've been successfully using bitmap indexes for years in Oracle environment. Now I'm working on a data warehouse project which will be hosted on SQL Server 2005. So far, I was unable to find an answer for bitmap like indexes in SQL Server. Any Ideas? ...
I'm in the process of tuning a pet project of mine to improve its performance. I've already busted out the profiler to identify hotspots but I'm thinking understanding Pythons performance characteristics a little better would be quite useful going forward. There are a few things I'd like to know: How smart is its optimizer? Some moder...
I have a view that uses 11 outer joins and two inner joins to create the data. This results in over 8 million rows. When I do a count (*) on the table it takes about 5 minutes to run. I'm at a loss as to how to improve the performance of this table. Does anyone have any suggestions on where to begin? There appear to be indexes on al...
I'm trying to get started with Android development. I'm using eclipse on Linux and using a Pentium IV @3.2Gh with 1GB of ram. I've just followed the "hello android" howto, with just one sad result: the virtualization is too slow. It seems that launching the virtual machine has to be slow, and it will be slow even if I'll use a bett...
Mac OS X 10.6 comes with OpenCL, but how many applications could have better performances if they would be rewritten to use OpenCL? What kind of applications should be rewritten to use OpenCL? ...
Hai Guys, I use 'n' number of server controls in my page... Now i am into performance tuning and i ve noticed that my viewstate is too large that it makes my page slow... I know viewstate size can be compressed by Gzip... Any other suggestions for reducing viewstate in asp.net.... I dont want to do in IIS because my web application is ...
Hi, This is a problem that my friend asked over the phone. The C# 3.5 program he has written is filling a Dataset from a Patient Master table which has 350,000 records. It uses the Microsoft ADO.NET driver for Oracle. The ExecuteQuery method takes over 30 seconds to fill the dataset. However, the same query (fetching about 20K records) ...
I have a table in PostgreSQL that I need read into memory. It is a very small table, with only three columns and 200 rows, and I just do a select col1, col2, col3 from my_table on the whole thing. On the development machine this is very fast (less than 1ms), even though that machine is a VirtualBox inside of a Mac OS FileVault. But on ...
What are some of the most expensive operations in PHP? I know things like overusing the @ operator can be expensive. What else would you consider? ...
I need to rewrite the query below so that it is as efficient as possible. Any suggestions on how to increase the performance of this query? I plan on setting columns t2_1 and t2_2 to not nullable and assigning a default value, I'm mainly curious as to if/how I can modify the join so that I can move the "WHERE ... IN ... " sections ther...
In general what makes an SQL query optimiser decide between a nested loop and a hash join. ...
Summary: How can I reduce the amount of time it takes to convert tifs to pdfs using itextsharp? Background: I'm converting some fairly large tif's to pdf using C# and itextsharp, and I am getting extremely bad performance. The tif files are approximately 50kb a piece, and some documents have up to 150 seperate tif files (each represent...
My question is what can I do to determine the cause of the slowness, or what can I do to speed it up without knowing the exact cause. I am running a simple query and it appears that the mapping back to the entities is taking taking forever. The result set is 350, which is not much data in my opinion. IRepository repo = ObjectFactory.G...
What all can we do to make a asp.net web application run faster than before. What are all the tweaking required for it ? ...
I have a WPF application which uses large amounts of frame based animations (100's MB worth of PNGs). Using the WPF Performance Suite tool "Perforator" I can see that, at times, the video memory being used is greater than is physically available on the GPU (512MB). I understand that GPU memory is virtualized from Vista onwards (>WDDM 2...
When I run a certain stored procedure for the first time it takes about 2 minutes to finish. When I run it for the second time it finished in about 15 seconds. I'm assuming that this is because everything is cached after the first run. Is it possible for me to "warm the cache" before I run this procedure for the first time? Is the ca...
I am trying to get some detailed performance information from an application my company is developing. Examples of information I am trying to get would be how long a network transaction takes, how much CPU/memory the application is using, how long it takes for a given method to complete, etc. I have had some failed attempts at this in t...
I recently had an app rejected from the app store because of Low Memory Exception. The app doesn't leak memory, but its base memory footprint seems to be too high. According to the crash logs sent by apple, it was taking about 14000 pages in the memory (mostly due to huge textures). There were 2 strange things though: I tested it on 5 ...
I'm posting this on behalf of a friend since I believe this is pretty interesting: Take the string "abb". By leaving out any number of letters less than the length of the string we end up with 7 strings. a b b ab ab bb abb Out of these 4 are palindromes. Similarly for the string "hihellolookhavealookatthispa...
Until now, I have not create any massive applications using ASP.Net. However, I am looking to create an application that has the potential to be very performance intensive. So I am looking for some tools or best practices when it comes to performance. I would like to be able to know how to: See my current performance (good or bad) Vi...