performance

How to store the following SQL data optimally in SQL Server 2008

I am creating a page where people can post articles. When the user posts an article, it shows up on a list, like the related questions on stackoverflow (when you add a new question). It's fairly simple. My problem is that i have 2 types of users. 1) Unregistered private users. 2) A company. The unregistered users needs to type in their...

java sparse matrix problem

Hi All, I have two dimensional matrix. My matrix is sparse. I am facing performance problem. Can any body please answer that what api or class i can use in java to handle sparse matrix to improve my program performance. For example I want it take 100x100 matrix handle sparse stuff do the multiplication return me my matrix same as 100x...

Help on Website response time KPI parameters

I am working on improving website performance. Here are the list of key performance indicators I am looking at for each page Total Bytes downloaded Number of requests DNS look up time FirstByte Download time DOM content load time Total load time Is there any optimum value for each KPI to indicate website performance? Please help me ...

In SQL Server, what performs better: where ProcessedDate is null or where Processed = 0

I am trying to decide on which approach to take in a database I am designing. I will be adding a ProcessedDate datetime null column in a table. It will be nullable for when the record has not been processed. So, is it worth having a Processed bit not null default 0 column as well? With the following queries: select * from tablename whe...

Are there any performance considerations from referencing a 5MB .Net assembly?

Today a co-worker mentioned he had issues with a large "enterprisey frameworky" project that when compiled was 5mb in size. The concern was that to use a even a small piece of functionality of the assembly you had to reference the entire thing and that is bad for some reason. I'm wondering if there are any performance or other disadvan...

What's the performance difference between DBI's fetchall_hashref and fetchall_arrayref?

I am writing some Perl scripts to manipulate large amounts (in total about 42 million rows, but it won't be done in one hit) of data in two PostgreSQL databases. For some of my queries it makes good sense to use fetchall_hashref because I have synthetic keys. However, in other instances, I'm going to have use an array of three columns ...

Any good(free/Open Source) sql query performance Analyzer tool..

I am using sql server 2005 and i want to measure some query performance using an analyzer tool.... Any good tool (free/Open Source) that you can refer..... ...

Realtime chart for WPF

Hello, We're developing a medical appliance and are wondering if there's a WPF chart that is able to receive new data every 10ms and present it. We tried ChartFX and DynamicDataDisplay and neither is good enough for this challenge. We'd appreciate any suggestions. ...

Does the ASP.NET C# page size matter

I have an asp.net web site that is based upon a single gateway page that typically handles all requests and responses. There are a number of classes that get called by the gateway page depending on what's going on, but there is a lot of code (around 25,000 lines) within the main gateway page, split into hundreds of methods. I understand...

mySql performance question about updating indexed field

I have a large table with a multi-part index. I need to run several queries to update a field that is part of the index. Basically every row will be updated. Would it be faster to drop the index, do all the updates and then re-add it? EDIT: Added question, why does it take so freaking long to DROP an index? Am I missing something or ...

Performance of DrawingVisual vs Canvas.OnRender for lots of constantly changing shapes

I'm working on a game-like app which has up to a thousand shapes (ellipses and lines) that constantly change at 60fps. Having read an excellent article on rendering many moving shapes, I implemented this using a custom Canvas descendant that overrides OnRender to do the drawing via a DrawingContext. The performance is quite reasonable, a...

OR query performance and strategies with Postgresql

In my application I have a table of application events that are used to generate a user-specific feed of application events. Because it is generated using an OR query, I'm concerned about performance of this heavily used query and am wondering if I'm approaching this wrong. In the application, users can follow both other users and group...

Random Complete System Unresponsiveness Running Mathematical Functions

I have a program that loads a file (anywhere from 10MB to 5GB) a chunk at a time (ReadFile), and for each chunk performs a set of mathematical operations (basically calculates the hash). After calculating the hash, it stores info about the chunk in an STL map (basically <chunkID, hash>) and then writes the chunk itself to another file ...

The performance (or other) differences between raw Socket and UdpClient?

Hello All. As we know .Net has UdpClient for simple Socket usage for UDP. Blockquote From MSDN. If you are writing a relatively simple application and do not require maximum performance, consider using TcpClient, TcpListener, and UdpClient. These classes provide a simpler and more user-friendly interface to Socket communications....

UI performance monitoring tools

I am looking for a tool that lets you monitor/log page rendering time on client machines. I am not looking for firebug/yslow because i want to know the following type of things: How does fast do my pages load when the user is in russia? How long does it take for javascript to run on some pages for everyone who accesses those pages? S...

SqlAlchemy optimizations for read-only object models.

I have a complex network of objects being spawned from a sqlite database using sqlalchemy ORM mappings. I have quite a few deeply nested: for parent in owner.collection: for child in parent.collection: for foo in child.collection: do lots of calcs with foo.property My profiling is showing me that the sqlalc...

Efficiency of putting a query in the C# foreach condition

Hi all: I came across this c# code in a project today and I couldn't help but question its efficiency: SPList spList = spWeb.GetListCustom("tasks"); foreach (SPListITem item in spList.GetItems(query)) { //... do something with the SPListCollection it returned } Being from a Java background, the spList.GetItems(query) definitely m...

Is the 64bit Windows platform immature? (even if comparing 32bit binaries with 64bit binaries running on it)

I compiled an 64bit binary of ioquake3 and an SDL binary to go along with it and I noticed on Windows 7 64bit, operation, while relatively stable, it doesn't have top notch performance. An equivalent binary on 64bit Debian, runs definitely faster, and perfectly stable. And I'm thinking: with all the major manufacturers still dispatchin...

Is jQuery faster than javascript?

Recently I had to convert some Javascript code to JQuery scripts. In this process I found that using JQuery do not speed up my site as much as I think. actually Javascript was faster in my case. So I want to know that, Is JQuery Faster than Javascript or not ? also Whats the main advantages of JQuery to Javascript ? ...

GetAll or GetList Functions And Performance Problem

Nowadays I see in some developers, use function named GetAll or Getlist in each class. These functions return a list or entity of it's class. After that, they use these function like this: dim k = from t in customer.GetAll, p in Product.GetAll where .... I think there will be a performance problem about this using. Because firstly a...