The application is on .Net 3.5 and Oracle Standard Edition 11G database where a table have over 2 million records. The record size is not huge. The records have a Status column of type Char(1). Depending upon the status a process picks records to process and updates the status after completion. A record goes via multiple processes in ser...
My friend use to developed 2-tier application which application connect directly to database, now he need to move to 3-tier application but he has issue about speed of the application. This new application need to generate a lot of reports at client side so he worried about speed of this process which need to call to business layer to qu...
Hey Guys, Is there any articles available online where can I find some tips on improving the iPhone application performance. I have read Apple docs on Memory Management and CPU cycles, but they are not very helpful. Also can someone suggest a few XCode settings that could improve the performance of the application (release version)? ...
I need to store binary files in a varbinary(max) column on SQL Server 2005 like this: FileInfo FileInfoId int, PK, identity FileText varchar(max) (can be null) FileCreatedDate datetime etc. FileContent FileInfoId int, PK, FK FileContent varbinary(max) FileInfo has a one to one relationship with FileContent. The FileText is meant...
I am beginning to break apart a large JSP file into a some smaller JSP pages so I can reuse this across other areas of the site. I can take the approach of leaving as a large Monolithic JSP file that takes params and adjusts it's behavior accordingly. The other approach I can take is breaking it apart so that it's called via jsp:i...
I have developed an application that will create lot of PDF's and serve those file. (Its normal Servlet-Buffering serving). How to make sure my application works efficient with multiple request? Is there any tool available to test the load/scalability/efficiency and how many parallel request does my code handle with the current server ...
I have two programs, one in C++, the other in assembler. I want to compare how much memory they use when running respectively. How can I do this? I am doing the testing on Windows, but I also would like to know how to do it on Linux. ...
Hello all, Was wondering if anyone had any favourite methods/ useful libraries for processing a tab-delimited text file? This file is going to have on average 30,000 - 50,000 rows in it. Just need to read through each row and throw it into a database. However, i'd need to temporarily store all the data, the reason being that if the tabl...
Assume no byte cache. Will the my_func be parsed before a & b are included, or after? $x=my_func(); //a.php and b.php are **very** heavy scripts include ('a.php'); include ('b.php'); //my_func makes the browser use it's cached version of the page. function my_func(){ //send caching headers //header(....); exit; } ...
I am implementing a simple TCP server using the select() method - everything is fine and performance is quite acceptable, but when benchmarking with ab (apachebench) the "longest request" is insanely high compared to the average times: I am using: ab -n 5000 -c 20 http://localhost:8000/ snippet: Requests per second: 4262.49 [#/sec]...
I am supporting a Java messaging application that requires low latency (< 300 microseconds processing each message). However, our profiling shows that the Sun Java Virtual Machine runs slowly at first, and speeds up after the first 5,000 messages or so. The first 5,000 messages have latency of 1-4 milliseconds. After about the first 5,00...
I'´m currently twiddling with an application that has a setup matching the following chat analogy: a chat is an object that is held in memory and contains a list of chat messages a chat is rendered in several browser windows and updates are pulled in with a4j:push The programmatic setup looks like this: an instance of a chat object w...
I need to write blocks of data (characters) and I don't care about the sequence of those blocks. I wonder what kind of OutputStream I should use to achieve high performance? ...
I heard somewhere that you should have your int type fields before all other types in your tables. They said the query runs faster or something. Is this true? For example - id int(10) time int(11) user_id int(10) title varchar(128) text text ...instead of: id int(10) title varchar(128) text text time int(11) user_id int(10) ...
Alright SQL Server Gurus, fire up your analyzers. I have a list of titles in application memory (250 or so). I have a database table "books" with greater than a million records, one of the columns of the table is "title" and is of type nvarchar. the "books" table has another column called "ISBN" books.title is not a primary key, is not...
It's easy to use the pre-compression module to look for a pre-compressed .gz version of a page and serve it to browsers that accept gzip to avoid the overhead of on-the-fly compression, but what I would like to do is eliminate the uncompressed version from disk and store only the compressed version, which would obviously be served the sa...
Hi, I'm getting some js errors only for some users, and only every once in a while on a page that uses quite a bit of ASP.NET AJAX. The page also does some intense SQL querying and some string manipulation to highlight text found in the search results. Could this be a result of performance? Is it always safe to use ASP.NET AJAX in de...
I have an existing SQL Server database whose structure I can't really change, although I can add stored procedures or new tables if I want. I have to write a stand-alone program to access the DB, process the data and produce some reports. I've chosen C# and Visual Studio as we're pretty much an MS shop. I've made a start at exploring us...
I recently did some performance testing and analysis of an ASP.NET application using out-of-process session state - this is necessary when using session state on a web farm so that state can be retrieved on any of the web servers, e.g. if subsequent HTTP requests arrive at a different server because the sessions aren't 'sticky' or the or...
Basically, I want GDI-type functionality in WPF, where I can write pixels to a bitmap and update and display that bitmap through WPF. Note, I need to be able to animate the bitmap on the fly by updating pixels in response to mouse movements. I've read that InteropBitmap is perfect for this, as you can write to pixels in memory and copy...