Is there any difference in performance when you break down a stored procedure into multiple procedures instead of having a big procedure?!
wich one is faster?!
for example:
mainSP
callSP1
callSP2
callSP3
end;
rather than
SP
....
.....
....
Thanks guys.
...
It seems that I often hear people criticize certain programming languages because they "have poor performance", or because some other language is "faster" in general (not necessarily for a specific application). However, my experience and education have taught me that anytime you have a performance problem, at least one of the following ...
As a result of the search for an answer of this question, I ran into a rather uncomfortable finding.
It seems that rendering only glClearColor() at 60 fps pushes the iPhone at 27% render utilization.
That means that doing hardly anything at all - only refreshing the screen - makes the iPhone use more than a quarter of its render capaci...
Hello,
There is very good compiler tcc and its library libtcc, that allows direct compilation of code inside code. i.e. Allows creation of self-generated code.
I'm looking for similar library for C++, if any exists. Or, I need and extremely fast reasonably good C++ compiler, so I may run it to generate shared object and dlopen it.
I do...
Oracle 10g has Profiles that allow various resources to be limited. Here are some references for clarity - orafaq.com, Oracle Documentation. I am particularly interested in limiting CPU_PER_CALL, LOGICAL_READS_PER_CALL, and COMPOSITE_LIMIT with the goal of preventing a poorly formed statement from destroying performance for every other...
The PIAB of the Microsoft Enterprise Library looks like it could be used for some pretty cool things. Many people were questioning how it would perform in real world applications, due to its use of remoting-based interception techniques. I haven't heard much about it recently and am wondering if anyone has had good or bad experiences f...
I have a WPF ListBox control (view code) and I am keeping maybe like 100-200 items in it. Every time the ObservableCollection it is bound to changes though it takes it a split second to update and it freezes the whole UI. Is there a way to add elements incrementally or something I can do to improve the performance of this control?
...
I have written a game in java script and while it works, it is slow responding to multiple clicks. Below is a very simplified version of the code that I am using to handle clicks and it is still fails to respond to a second click of 2 if you don't wait long enough. Is this something that I need to just accept or is there a faster way t...
I have the following function which is called for every line item produced. Does anyone have any ideas how to speed this up?
private String getDetails(String doc){
String table="";
java.sql.ResultSet rs = qw.DBquery("select " +
"id,LineType, QtyTotal, ManufacturerPartNumber, Description, UnitCost,UnitPrice " +
...
Hello,
Am currently considering using REST access to Nirvanix online storage to store/download files. However, Nirvanix also offers NFS access to the network storage.
I was wondering if there are any known benchmarks or protocol-specific reasons for choosing REST over NFS?
thanks.
...
Assuming I have a cluster of n erlang nodes, some of which may be on my LAN, while others may be connected using a WAN (i.e. via the internet), what are suitable mechanisms to cater for a) different bandwidth availability/behavior (e.g. latency induced) and b) nodes with differing computational power (or even memory constraints for that ...
I want to cache data on the client. What is the best algorithm/data structure that can be employed?
Case 1. The data to be stored requires extremely fast string searching capability.
Case 2. The cached data set can be large. I don't want to explode the client's memory usage and also I don't want to make a network and disk access calls w...
Hi,
I'm using std::map to store a lot of elements (pairs of elements) and I have a "little" doubt, what is more efficient to iterate all elements over my std::map, iterator or reverse_iterator?
Thank's.
Salu2.
...
I am benchmarking a custom brower and want to benchmark the rendering speeds of different types of images (gif, jpg, png) of the same file size to see which of the image formats this browser renders the fastest.
My process was just to have a simple seperate HTML page for each type of image and just use a Javascript counter before it is ...
I have an image that is around 1200 x 400 (if I remember right), and is about 50kb in size. I use the image in a header for a website, but I constrict the height of the image to 100px in order to make it fit my header.
<asp:Image ID="imgLogo" runat="server" ImageUrl="~/Images/AFact.jpg" Height="100px" />
Is this a bad practice? Does ...
One of my colleague told me that implementing interfaces have an overhead. Is this true?
I am not concerned about micro optimizations, just want to know the deeper details this entails.
...
Before we sign up for any hosting company to host our app or pages, i think it probably is good to find out the speed so that if it is too slow, we may as well pay a little more to find a better place to put our app. the question is, is there a way to find out some sites that a hosting company is hosting and what is the best way to test...
I am developing an application where I have a requirement that I have to include multiple files, as follows:
File1.php will include File2.php
File2.php will include File3.php
File3.php will include File4.php
Now, what will be the best and optimized way of doing these. I tried with include() but I think its slowing down my server as ...
Something that takes 1 second to run on Linux takes 45 seconds to run on AIX. I haven't dug directly into that code but as a test grabbed a small application that does very little from another SO question:
int main ( int argc, char **argv)
{
int i = 0;
std::vector<int> vec;
vec.push_back(6);
vec.push_back(-17);
vec.push_back(12);
for ...
I've developed a web application using MyFaces 1.2.6 and Richfaces 3.3.1GA (just upgrated).
Despite the ease of use, I found out that Richfaces components are very slow.
I also found out that they didn't really take advantage of the browser caching mechanism, they keep sending some lousy JS file every request and other things.
I really ...