I have an iPhone app that grabs information from different sources in XML format. For example i have a UITableView displaying information, in xml format after being parsed, from an url like this one http://mysite.com/posts.php?top=100 -> returns posts information like this <postsList><post><title>test1</title><pubDate>..</pubdate></ite...
ALTER PROCEDURE ReadNews @CategoryID INT, @Culture TINYINT = NULL, @StartDate DATETIME = NULL, @EndDate DATETIME = NULL, @Start BIGINT, -- for paging @Count BIGINT -- for paging AS BEGIN SET NOCOUNT ON; --ItemType for news is 0 ;WITH Paging AS ( SELECT news.ID, news.Title, news.Description, news.Date,...
Worrying about my web application's performances, I am wondering which of "if/else" or switch statement is better regarding performance? ...
A little question regarding performance in a Java web app. Let's assume I have a List<Rubrique> listRubriques with ten Rubrique objects. A Rubrique contains one list of products (List<product> listProducts) and one list of clients (List<Client> listClients). What exactly happens in memory if I do this: listRubriques.clear(); listRub...
Here's a brain-twister for the SQL guys - can anyone think of a reason why the first of these functions performs fine, and the second one runs dog-slow? Function A - Typically finishes in ~5 ms CREATE FUNCTION dbo.GoodFunction ( @IDs UniqueIntTable READONLY ) RETURNS TABLE AS RETURN SELECT p.ID, p.Node, p.Name, p.Level FROM...
I have an idea of monitoring all SQL queries on a spare monitor which is almost not used in my daily coding. You can see latest SQL queries in runtime. Obviously this is not unique. But I just want to know your opinion on this. Can this approach be useful? Can it help to detect a problems in your SQL queries faster? Can it help you in ...
what is the difference between these two statements? which is better with respect to performance? Console.Writeline(i); Console.Writeline(i.toString()); where i is a string or an integer. ...
Hi, I have the following code doing Sin/Cos function using a pre-calculated memory table. in the following example the table has 1024*128 items covering all the Sin/Cos values from 0 to 2pi. I know I can use Sin/Cos symmetry and hold only 1/4 of the values but them I will have more 'ifs' when computing the value. private const double P...
I have a program written in C that allows the user to scroll through a display of about a zillion small files. Each file needs to undergo a certain amount of processing (read only) before it's displayed to the user. I've implemented a buffer that preprocesses the files in a certain radius around the user's position, so if they're worki...
Hi everyone, I'm trying to make post voting something similar to stack overflow vote up and vote down, now I made it work with (but-it-works approach) and yet something doesn't feel right, hopefully someone will suggest some useful tweaks. Here is my jquery code : var x = $("strong.votes_balance").text(); $("input.vote_down").click(...
Hi all, I have stumbled on an impossibly good performance behaviour with PostSharp. To evaluate the speed I wrote a little program, that would execute one function a specified number of times, and if PostSharp is enable it would generate and delete a few hundred strings, just in memory (non fixed composition, so they are not auto-intern...
I'm implementing some basic animations in canvas, when I came across an interesting issue. It appears that Firefox is rendering my text much more smoothly when animated, then the Chrome or WebKit nightlies. Is this a problem with my code or is there a performance issue with fillText in Webkit/Chrome? edit I forgot to mention in my actu...
I have three different laptops with Python2.5 on it. If I run Pystone I get essentially the same values. Intel Pentium M @1.80GHz - 1.5GB RAM Intel T2300 @1.66GHz - 1GB RAM Intel Pentium Dual T2370 @1.73Ghz - 2GB RAM These are their respective Pystone values: 45787 pystones/second 44377 pystones/second 43861 pystones/second I don...
I am using VSTO to fill data into a table in a Microsoft Word 2007 template. The amount of data varies and filling many pages (+50) takes a lot of time. The code I use to create a table: Word.Table table = doc.Tables.Add(tablePosition, numberOfRows, 8, ...
We have currently a Postgres database with a 100 of tables 20 of them with more than 5 000 000 rows, the master DB server runs on Debian 32MB RAM 8 Processors. Additionaly to the master DB we have a Slave DB replicated using Slony. Our application uses Java and Hibernate framework for SQL query, c3p0 as connection pool. Our problem is...
ps:let alone the code complexity of closure implementation of the same task. ...
Hello, we've got an application developed in java, with GWT providing the frontent. The application is used on a variety of hardware specifications, e.g. also on older machines. Of course users complain about performance. We'd like to collect profiling data from real-world users. So far we can measure the pure server-side duration (tha...
Hi all, I have some question regarding database performance in general. I'm using Sqlite but I assume that the performance remarks are applicable to all relational databases? I have a database that contains a table that stores data of about 200 variables. I write about 50 variables per second to the table. A writen variable contains th...
If i devlop a chat application using django will it have some performance problem? Can i do server push in django? I want to have PM and room discussions as well. ...
I'm writing a webapp (Firefox-compatible only) which uses long polling (via jQuery's ajax abilities) to send more-or-less constant updates from the server to the client. I'm concerned about the effects of leaving this running for long periods of time, say, all day or overnight. The basic code skeleton is this: function processResults(xm...