performance

Check if an element exists

I'm trying to find out if an Element in a Django model exists. I think that should be very easy to do, but couldn't find any elegant way in the Making queries section of the Django documentation. The problem I have is that I've thousands of screenshots in a directory and need to check if they are in the database that is supposed to stor...

Image viewer performance issues in WPF

Hi all. I'm having issues with a image displayer in WPF. I've a ListView displaying ImageSources. <Setter Property="ItemsPanel"> <Setter.Value> <ItemsPanelTemplate> <WrapPanel /> </ItemsPanelTemplate> </Setter.Value> </Setter> ...

mysql query performance

Hi folks! Can somebody give a hint on this one? : I have a table, let's say tblA, where I have id1 and id2 as columns and index(id1,id2). I want to select the id1´s where id2´s belong to several sets. So I would want to say select id1 from tblA where id2 in (val1,val2,val3 ...) union select id1 from tblA where id2 in (val4,val2,val3...

Which schemaless datastores provide good performance?

I've recently written a web app that uses couchdb. I like couchdb and it suited the app - which has a lot of dynamic behaviour and simply pulls JSON directly from couchdb. Being able to upload images via a browser is nice and it's a snap to do tweaks to document data. The replication also has made deployment a breeze as the app is a couc...

How can one determine page render time in Spring (on Google App Engine/Java)?

We are building an application on Google App Engine in Java using Spring 2.5. I would like to put something in the footer that displays page render time. Where are the best code hooks in either Spring or GAE/J to calculate render time and put it into the Spring model for JSP rendering? ...

Does streaming media in SharePoint pose a performance risk?

Can anyone comment on the performance implications of storing streaming media in a SharePoint 2007 document library? I’ve heard this can be detrimental to the performance of the farm due to the media being streamed from storage in a SQL DB. Has anyone had any firsthand experience with this and if so, what alternatives have you used to p...

Good blogs/articles/ books on building highly scalable systems?

Any good blogs/articles/ books on designing highly scalable systems? Good source code for studying would help a lot too. ...

Calculating a round order of magnitude

For a simple project I have to make large numbers (e.g. 4294967123) readable, so I'm writing only the first digits with a prefix (4294967123 -> 4.29G, 12345 -> 12.34K etc.) The code (simplified) looks like this: const char* postfixes=" KMGT"; char postfix(unsigned int x) { return postfixes[(int) floor(log10(x))]; } It works, but...

MySQL query over many-to-many realtion: unions?

In addition to this question http://stackoverflow.com/questions/1202668/problem-with-sql-query which had very neat solution, I was wondering how the next step would look: DOCUMENT_ID | TAG ---------------------------- 1 | tag1 1 | tag2 1 | tag3 2 | tag2 3 | tag1 3 ...

Slow SQL Updates within a Cursor

I've added a new column, packageNo, to my table: create table Packages( id varchar(20) primary key, -- ok, I know :) orderNo uniqueIdentifier not null, orderlineNo int not null, packageNo int not null default(0) ) Now I want to generate the packageNo with the following rules: reset it for each order ascendantfor order, or...

understanding ajax a bit more

Does anyone have a complete start-to-end set of steps taken when making an ajax call? is it different then a http request? Via perception, it seems an ajax populated web page takes more time then a php populated one: both accessing the same db, same # of records, same display, difference being in-line php to render the form prior to sen...

Minimise database updates from changes in DataTable/SqlDataAdapter

My goal is to maximise performance. The basics of the scenario are: I read some data from SQL Server 2005 into a DataTable (1000 records x 10 columns) I do some processing in .NET of the data, all records have at least 1 field changed in the DataTable, but potentially all 10 fields could be changed I also add some new records in to the...

How to improve the performance of Eclipse IDE under QNX6

We are running Eclipse over QNX6 in a VMWare environment and it's very slow. Eclipse is launched like this: /usr/qnx630/host/qnx6/x86/usr/qde/eclipse/eclipse -data /root//workspace /usr/qnx630/host/qnx6/x86/usr/qde/eclipse/jre/bin/pvm -pri 13 -ts 4 -gs 4 -gcperiod 500 -cs 512000 -nojit -numregs 64 -maxmem 256M -Djava.version -classp...

Optimal number of connections in connection pool

Currently we are using 4 cpu windows box with 8gb RAM with MySQL 5.x installed on same box. We are using Weblogic application server for our application. We are targeting for 200 concurrent users for our application (Obviously not for same module/screen). So what is optimal number of connections should we configured in connection pool (m...

How to calculate the frames per second(fps) performance of a video decoder?

Hello, How do we get the performance of a video decoder as to how many frames it can decode per second. I know following parameters are used to arrive at fps but not able to relate them in a formula which gives the exact answer: seconds taken to decode a video sequence, total number of frames in the encoded video sequence, clock rate o...

Is there a faster way to deploy WSIT Services than autodeploy?

We've recently upgraded our services technology stack. We opted for the WSIT implementation of JAX-WS. Currently, we're relying on our Glassfish Application Server to deploy the web service automatically based on the JAX-WS annotations. We have about two dozen different services and hundreds of operations, so this autodeployment take...

What's the maximum number of HTTP connections I can have open in one Windows Server 2008 box?

I have a web server hosting an HTTP chat application that works with long-polling. This means a client browser "polls" for new info and the server does not respond until there is info to send back, so the HTTP connection is left open for a long time, up to a minute. My question is how many of these connections the server can handle ope...

JMeter versus The Grinder?

I'm looking at stress testing our website and having trouble picking the right tool. It looks to me like two of the most popular are JMeter and The Grinder. Can anyone help with reasons in favor of either? Thanks! ...

Making a SQL Query More Efficient

I have a query along the lines of select b.* from (select key, max(val) as val from (somequery) group by key) as a inner join (somequery) as b on a.key = b.key and a.val = b.val order by key And I was wondering if there is an obvious way (that I am missing) to simplify it (given that somequery might be rather long). Any thoughts woul...

C# List<T> vs IEnumerable<T> performance question

Hi suppose these 2 methods: private List<IObjectProvider> GetProviderForType(Type type) { List<IObjectProvider> returnValue = new List<IObjectProvider>(); foreach (KeyValuePair<Type, IObjectProvider> provider in _objectProviders) { if ((provider.Key.IsAssignableFrom(type) || ...