performance

Creating high performance animations in WPF

Hi All, I'm in a situation that requires many animations with effects like transparency to be applied but when there are about 10 of them running, my application slows down to a grinding halt! :( I also, tried implementing a particle like effect using a frame by frame manual animation using the CompositionTarget.Rendering event, which ...

Inserting items in a list that is frequently insertion sorted

I have a list that is frequently insertion sorted. Is there a good position (other than the end) for adding to this list to minimize the work that the insertion sort has to do? ...

Efficient way to store content translations?

Suppose you have a few, quite large (100k+) objects in available and can provide this data (e.g. name) in 20+ languages. What is an efficient way to store/handle this data in a SQL database. The obvious way to do that looks like this - however, are there other ways which make more sense? I'm a bit worried about performance. CREATE TA...

How do I optimize these ocaml functions for dynamic interval scheduling?

I have a program that solves the weighted interval scheduling problem using dynamic programming (and believe it or not, it isn't for homework). I've profiled it, and I seem to be spending most of my time filling M with p(...). Here are the functions: let rec get_highest_nonconflicting prev count start = match prev with head :...

Many connections vs. big data queries

Hello I am creating a windows application that will be installed in 10 computers that will access the same database thru Entity Framework. I was wondering what's better: Spread the queries into packets (i.e. load contact then attach the included navigation properties - [DataContext.Contacts.Include("Phone"]). Load everything in one qu...

Performance in tables with binary data/images

I made a people maintenance screen. The client want me to store the photo of every person in the database, and I made it without problems. I have a separate table for the images with two fields, Id_person,and Image. I'm a little worried because it's the first time that i work with images in database. will I have problems of performance ...

Best way to test if a row exists in a MySQL table

I'm trying to find out if a row exists in a table. Using MySQL, is it better to do a query like this: SELECT COUNT(*) AS total FROM table1 WHERE ... and check to see if the total is non-zero or is it better to do a query like this: SELECT * FROM table1 WHERE ... LIMIT 1 and check to see if any rows were returned? In both queries, ...

Performant File Copy in C#?

I have a huge directory of about 500k jpg files, and I'd like to archive all files that are older than a certain date. Currently, the script takes hours to run. This has a lot to do with the very piss-poor performance of GoGrid's storage servers, but at the same time, I'm sure there's a way more efficient way Ram/Cpu wise to accomplish...

What is different linq to sql where clause

what is the different between the two 1) context.connection.open() var albums = (from a in context.Albums where a.id == id select a); context.connection.close() 2) context.connection.open() var albums = (from a in context.Albums select a); context.connection.close() var result = albums...

Performance of sql Count*

asp.net and sql server, have sqls for selecting a subset of rows, I need the count* frequently Of course I can have a select count(*) for each of these sqls in each roundtrip but soon it will become too slow. -How do you make it really fast? ...

Pretty format sql in .NET code, performance?

Hi, Will the compiler optimize pretty formatted strings, or will that code run slower than strings that are not divided in a readable way? for example string sql = "select * " + "from person " + "where id = :id"; or string sql = "select * from person where id = :id"; This is just a small example. You know how complicate...

What do you monitor with JMX in your production java application?

This question is not about how JMX works or what JMX does. This question is about applications of JMX in standard application server environment in production. It is not for specific server either. What do you monitor with JMX in production environment that runs standard stack of JEE services: database access (JDBC and JPA), session EJ...

Can I enforce the order of XML attributes using a schema?

Our C++ application reads configuration data from XML files that look something like this: <data> <value id="FOO1" name="foo1" size="10" description="the foo" ... /> <value id="FOO2" name="foo2" size="10" description="the other foo" ... /> ... <value id="FOO300" name="foo300" size="10" description="the last foo" ... /> </data> Th...

When should one avoid using NHibernate's lazy-loading feature?

Most of what I hear about NHibernate's lazy-loading, is that it's better to use it, than not to use it. It seems like it just makes sense to minimize database access, in an effort to reduce bottlenecks. But few things come without trade-offs, certainly it slightly limits design by forcing you to have virtual properties. But I've also ...

Why is PLSQL slower than SQL*Plus

I have several Oracle queries that perform well when run through SQL*PLUS. However when they are executed as a part of a PL/SQL package, they take MUCH longer. Our DBA has watched these queries take 10 minutes through PLSQL and 10 seconds through SQL*Plus. Does anybody have any pointers on where to look for the misconfiguration? Clie...

my experiment shows that rendering order affects performace alot in TBR architecture. why???

Hi, TBR chips perform HSR (hidden surface removal) before fragment processing, so only the visible pixels are rendered. This feature results in no necessary sorting opaque objects from front to back. But i have done a experiment on my iPhone 3GS. By comparing the frame time, rendering opaque objects from front to back is much faster tha...

Inspiration needed: Selecting large amounts of data for a highscore.

I need some inspiration for a solution... We are running an online game with around 80.000 active users - we are hoping to expand this and are therefore setting a target of achieving up to 1-500.000 users. The game includes a highscore for all the users, which is based on a large set of data. This data needs to be processed in code to ...

Why a View is loading very slow for the first time in a Prism composite wpf application

Displaying a View inside a Region is about 5-10 seconds slow for the first time, and UI freezes for that period in my Prism Composite WPF application. In subsequent times View is loaded relatively faster without any UI freezing. View is composed of a Devexpress WPF Grid control and data is fetched from a SQL database. I don't think its a...

What's the most efficient way to compare two blocks of memory?

I need a comparison function for blocks of memory for doing binary searches on arrays of bytes in the D programming language. It does not need to have any useful semantics. It only needs to be fast and be a valid comparison function (one that produces a total ordering). The blocks of memory to be compared are already known to be the s...

Wpf Animation performance drops suddenly

I have a simple fade in animation on a large Rectangle inside a ScrollViewer and I notice a significant drop in performance when I increase my windows size past a certain size. resolution: 1650x1256 - still feels snappy and fluent (framerate between 50 and 60) resolution: 1820x1256 - stutters and is pretty much unusable (framerate betw...