Top "Performance" questions

For questions pertaining to the measurement or improvement of code and application efficiency.

INNER JOIN vs LEFT JOIN performance in SQL Server

I've created SQL command that uses INNER JOIN on 9 tables, anyway this command takes a very long time (more than …

sql sql-server performance
MySQL vs MongoDB 1000 reads

I have been very excited about MongoDb and have been testing it lately. I had a table called posts in …

mysql performance mongodb
numpy: most efficient frequency counts for unique values in an array

In numpy / scipy, is there an efficient way to get frequency counts for unique values in an array? Something along …

python arrays performance numpy
Extreme wait-time when taking a SQL Server database offline

I'm trying to perform some offline maintenance (dev database restore from live backup) on my dev database, but the 'Take …

database sql-server-2005 performance
How can I determine whether a 2D Point is within a Polygon?

I'm trying to create a fast 2D point inside polygon algorithm, for use in hit-testing (e.g. Polygon.contains(p:…

performance graphics collision-detection polygon point-in-polygon
Append an object to a list in R in amortized constant time, O(1)?

If I have some R list mylist, you can append an item obj to it like so: mylist[[length(mylist)+1]] &…

r performance list append big-o
Fastest way to remove first char in a String

Say we have the following string string data= "/temp string"; If we want to remove the first character / we can …

c# string substring performance trim
MyISAM versus InnoDB

I'm working on a projects which involves a lot of database writes, I'd say (70% inserts and 30% reads). This ratio would …

mysql database performance innodb myisam
How to get object size in memory?

I need to know how much bytes my object consumes in memory (in C#). for example how much my Hashtable, …

c# .net performance memory profiling
When to use StringBuilder in Java

It is supposed to be generally preferable to use a StringBuilder for string concatenation in Java. Is this always the …

java string performance