Certainly there is some type of context switching, marshaling, serializing, etc that takes place when you choose to write a stored procedure in NET vs T/SQL. Are there any hard facts about this overhead as it relates to making a decision about using .NET vs T/SQL for stored procedures? What factors do you use in order to make the decis...
We are looking at stress testing a NAS system for a Database, basically was want to see how much abuse it can take and how much it affects the Database performance. here is what we have planed I have a test Tool I'm building that will kickoff a configurable number of threads that run a sql query (also configurable, and thinking abou...
I'm looking for a new language to learn after C++, Java, obj C, HTML, css, and js. I originally was going to try C# but a bunch of people say its really slow because its a high level language. So why would anybody use C#? Isn't C++ much faster? Does it make development easier, but just have a slower final product? Also, what can C# be us...
I'm trying to set a huge (200K) response to innerhtml of a node. The goal is to get better time than 2.7 sec in internet explorer 6. Any ideas?, Thanks ...
I am just learning how to use Terracotta after discovering it about a month ago. It is a very cool technology. Basically what I am trying to do: My root (System of Record) is a ConcurrentHashMap. The main Instrumented Class is a "JavaBean" with 30 or so fields that I want to exist in the HashMap. There will be about 20000 of these J...
The problem is: Given a number of programming libraries with similar or equal scope (e.g. XML parser, regex, markup, ...); are there tools, with which one can run performance tests on these libraries and compare (and generate reports), even though the libraries may be written in different programming languages (such as java, C#, ruby, py...
And how would it pertain to performance and memory issues? Is it more a problem on AIX than Solaris or Windows? ...
My application is storing location data from GPS inputs. When importing a GPX file, a user can have from 500 - 10,000 GPS datapoints. Right now, I have a model for each trackpoint. It's working great, but on insert it is SLOW. 30+ seconds for the 10,000 datapoints. Is there any better way of bulk inserting? All the time is spent ...
Is there any performance counter? Or i really get result like that: Jagged Arrays: 2000 ms Arrays : 3000 ms ArrayList : 4000 ms How can i code method to get performance result? ...
In MySQL, we have an option to have separate file for tables. I just wanted to know if using this option would decrease performance,for example in querying tables. ...
I am working on a project has me constantly pinging a php script for new data, so if I understand this correctly that means that the php script being pinged gets run over and over indefinitely. It works but i'm guessing its a huge strain on the server, and is probably considered ugly and bad practice. Am I right about that? Is there any...
I have a question for all the hardcore low level hackers out there. I ran across this sentence in a blog. I don't really think the source matters (it's Haack if you really care) because it seems to be a common statement. For example, many modern 3-D Games have their high performance core engine written in C++ and Assembly. As far...
We have a product built on the Client-Server architecture. Some details about the technology stack used. Client - Java Swing Server - RMI Java Database - Oracle The clients are located at different parts of the world but the java server & the oracle database are located on the same machine at Sweden. Because of this there is a lo...
I'm looking to introduce some database denormalization to a heavily normalized system. I have a large set of databases that have evolved over ten years and are under increasing amounts of load so I'm looking to improve PERFORMANCE and possibly reduce the complexity of some queries. It is not uncommon to do 10 joins to accomplish any ...
Let A and B be two tables in a database schema. A and B are related by a many-to-one relationship. There exists many B's for each A, and B has a foreign key column a_id. Both tables have a primary key column id. Which of the following two queries performs better for large data sets in A and B? SELECT A.* FROM A,B WHERE A.id = B.a_id...
Is there any way to speed up the initialization of javax.xml.bind.JAXBContexts with a large (>1000) number of classes? In our XML heavy application the startup time is some 10 minutes and consists mainly of the initialization time of the JAXBContexts. :-( We are using Sun's JAXB implementation in the JDK 1.5 and the org.jvnet.jaxb2.mave...
Someone has used a configuration enabling the garbage collector optimized for multi-processor machines using Aspnet.config with : gcServer enabled="true" gcConcurrent enabled="true" There was improvement in the performance of your site? It was noticed a problem? ...
I have a a simple ordered list that could contain 1 million or more items. There are only a few actions that are done with this list: lookup in a value exist find the index for a value find value for index add a value get number of items in the list Once a value is added to the list, it never changes. I append items to the list, no i...
I'm trying to find a way to test how long it takes a block of C++ code to run. I'm using it to compare the code with different algorithms and under different languages, so ideally I would like a time in seconds / milliseconds. In Java I'm using something like this: long startTime = System.currentTimeMillis(); function(); long stopTime...
Hi all. I'm interested in data mining projects, and have always wanted to create a classification algorithm that would determine which specific check-ins need code-reviews, and which may not. I've developed many heuristics for my algorithm, although I've yet to figure out the killer... How can I programmatically check the computationa...