performance

Is it possible for a Perl DBI script to do "buffered inserts" on db2?

Buffered Inserts are a feature of db2 allowing one to get greater insert performance. IBM's documentation describes needing to bind this option to your application. I can't figure out if this is possible to do with the Perl DBI interface, and if it is possible, how to do it. ...

SSL Slow in IE 8.0.7600.16385IC

I'm having a performance problem on my company's web site using a specific version of IE 8 to load a page using https. Here's what I know. Server: Virtual machine running on VMWare ESX Windows Server 2003 Enterprise Edition SP 2 Tomcat 6.0.16 Client: Windows XP and Window 7 Internet Explorer 8.0.7600.16385IC Page loads/refreshes in u...

Best Order to traverse a Bellman-Ford Algorithm to achieve min. number of iterations?

Hey everybody, What is the Best oder of traversing edges within Bellman-Ford algorithm in Order to achieve a min. number of iterations necessary.? thx in advance, Andreas ...

Best practice or performance difference between ToString() and & concatenation

When I am concatenating object values together to form a string in VB.NET, is there a difference in performance or a recommended best practice between using the & concat or the + concat with calls to .ToString() on each object? Example (which is faster or best practice): Dim result1 As String = 10 & "em" Dim result2 As String = 10.ToSt...

Database indexing - how does it work?

how does indexing increases the performance of data retrieval? How indexing works? ...

Star Schema vs Snowflake Schema performance

Hi... I'm begin to developing a scial sharing website so I'm curious about database design Schema... So in Data-Mining Star-Schema is the best one but how about a social sharing website... And as a nature of the SS websites there will be (i hope :)) many users in same time... Which better for performance for overdose using... ...

Is there performance to be gained by moving storage allocation local to a member function to its class?

Suppose I have the following C++ class: class Foo { double bar(double sth); }; double Foo::bar(double sth) { double a,b,c,d,e,f a = b = c = d = e = f = 0; /* do stuff with a..f and sth */ } The function bar() will be called millions of times in a loop. Obviously, each time it's called, the variables a..f have to be allocated....

NHibernate unintentional lazy property loading

I introduced a mapping for a business object which has (among others) a property called "Name": public class Foo : BusinessObjectBase { ... public virtual string Name { get; set; } } For some reason, when I fetch "Foo" objects, NHibernate seems to apply lazy property loading (for simple properties, not associations): The foll...

What are provenly scalable data persistence solutions for consumer profiles?

Consumer profiles with analytical scores [ConsumerID, 1..n demographical variables, 1...n analytical scores e.g. "likely to churn" "likely to buy an item > 100$ in worth" etc.] have to be possible to query fast if they are to be used in customizing web-sites, consumer communications etc. Well. If you have: Large number of consumers La...

Oracle, slow performance when using sub select

I have a view that is very slow if you fetch all rows. But if I select a subset (providing an ID in the where clause) the performance is very good. I cannot hardcode the ID so I create a sub select to get the ID from another table. The sub select only returns one ID. Now the performance is very slow and it seems like Oracle is evaluating...

Which is faster: Cloning or using Streams?

In Java, which is faster: Cloning an Object, then passing it to multiple listeners assuming the cloned object contains nothing more complicated than nested arrays, primitives and Strings Using Streams to pass data through from one object to another? ...

C++ Adding 2 arrays together quickly

Hello! Given the arrays: int canvas[10][10]; int addon[10][10]; Where all the values range from 0 - 100, what is the fastest way in C++ to add those two arrays so each cell in canvas equals itself plus the corresponding cell value in addon? IE, I want to achieve something like: canvas += another; So if canvas[0][0] =3 and addon[0...

What flags are enabled by -XX:+AggressiveOpts on Sun JRE 1.6u20?

From Sun JRE performance tuning whitepaper, -XX:+AggressiveOpts flag is described as: Turns on point performance optimizations that are expected to be on by default in upcoming releases. The changes grouped by this flag are minor changes to JVM runtime compiled code and not distinct performance features (such as BiasedLoc...

Physical cache vs Logical cache

What is the pros and cons of: - Physical cache (between MMU and Memory) - Logical cache (between CPU and MMU) from a programmer's view? How to get the best of each of them? Thanks ...

Best practice for handling memory leaks in large Java projects?

In almost all larger Java projects I've been involved with I've noticed that the quality of service of the application degrades with the uptime of the container. This is most probably due to memory leaks in the code. The correct way to solve this problem is obviously to trace back to the root cause of the problem and fix the leaks in th...

304 latency vs inlined javascript

There seems to be a general conclusion floating around the internet that external js files are better. The main reasons are caching, maintenance, and debugability. However there does not seem to be much discussion on the overhead of the 304 http requests. I went to yahoo.com, and noticed that 304's for each javascript file has an overh...

Android Performance Question : Many small apps or one big app?

I read this quote in one of the webpages: If you are writing a large application, consider dividing it into a suite of applications and services. Smaller applications load faster and use fewer resources. Making a suite of applications, content providers, and services makes your code more open to incorporation into other...

How to modernize an enormous legacy database?

I have a question, just looking for suggestions here. So, my application is 'modernizing' a desktop application by converting it to the web, with an ICEFaces UI and server side written in Java. However, they are keeping around the same Oracle database, which at current count has about 700-900 tables and probably a billion total records...

Faster code with another compiler

I'm using the standard gcc compiler in math software development with C-language. I don't know that much about compilers or compiler options, and I was just wondering, is it possible to make faster executables using another compiler or choosing better options? The default Makefile sets options -ffast-math and -O3 and I think both of them...

How can Bookmark look up be ignored?

Bookmark look up is taking long time when executing a SQL 2000 query. How can this issue be solved using Query hint or Index? ...