We have a passwords table which references a user table. Records never get deleted from the password table so if a user changes their password, a new entry with a more recent Created date gets inserted. The hash of the password is salted with various things, most importantly the created date of the actual record. In a stored procedure...
Background: In the current project I am working on, I have created a jquery plugin that creates a draggable 'google-maps'-esque map, made up of many tiles. Similar to how google map works, but without the zoom at this point. This map plugin creates and destroys 10-20 <div> tiles per mouse being dragged one tile length using jQuery's $(...
I'm investigating performance on an operation. I'm iterating a subset of items from a collection. I filter this collection using a Linq query. It basically looks like this: var filteredItems = items.Where(x => x.PropertyToFilterOn == filterValue); foreach (var filteredItem in filteredItems) { // do something to the filtered item } ...
I'm working on a simple job threading framework which is very similar to the one described in id Tech 5 Challenges. On the most basic level, I have a set of lists of jobs, and I want to schedule these list across a bunch of CPU threads (using a standard thread pool for the actual dispatching.) However, I wonder how this signal/wait stuff...
Hi all, writing a game and using mouse events for the first time, but as i play with them, the various methods are getting bigger, i want to seperate the listening stuff into a diffrent class, but i will still need acsess to my various objects that are stored in my main class (where the listener methods currently resides having used imp...
I'm implementing a GUI built on top of OpenGL. I came to the problem that each GUI will have -- text rendering. I know of several methods of rendering text in OpenGL, however, I'm wonderin which of them would be best suited for a GUI. Generally in a GUI we have two types of text -- static and live. Static is easy enough -- we can render...
There is a substantial MySQL database with data weighting hundreds of gigabytes. It experiences performance problems. Vertical and horizontal partitioning of tables are possible roads to increase performance. In your opinion would splitting this database into several databases be beneficial to increase performance as well? The project ...
I am building a lot of auto-generated code, including one particularly large file (~15K lines), using a mingw32 cross compiler on linux. Most files are extremely quick, but this one large file takes an unexpectedly long time (~15 minutes) to compile. I have tried manipulating various optimization flags to see if they had any effect, wi...
I have a site that is roughly one half "my" site, and one half a SAS site from a third party. We've been trying to tackle a single sign on method for many moons. It dawned on me recently that if I did some URL rewriting to display the third party site, but appear on our domain, the third party cookies would be written as coming from my...
I have a large array with around 20k objects in it. Each object has child objects in a big complicated tree structure with arrays in there too. Right now the app is developed using just a simple myObjectType[] myArray and it takes 13 seconds just to get the count of items in the array. Is there a better type or is there a better way ...
I use C# to write windows applications with the .NET framework. How can I decrease startup time for these applications? My applications feel very slow during startup and initialization, particularly when showing the initial form. My application works with an Access (MDB) database to save data. In some forms it loads data, but the first ...
I am using the .NET Chart Control library that comes with .NET 4.0 Beta 2 to create and save images to disk on a background thread. I am not showing the chart on the screen, however, simply creating a chart, saving it to disk, and destroying it. Something like this: public void GeneratePlot(IList<DataPoint> series, Stream outputStream...
Many years ago, C compilers were not particularly smart. As a workaround K&R invented the register keyword, to hint to the compiler, that maybe it would be a good idea to keep this variable in an internal register. They also made the tertiary operator to help generate better code. As time passed, the compilers matured. They became v...
Possible Duplicate: Do try/catch blocks hurt performance when exceptions are not thrown? Hey everyone, Just a quick question about try..catch blocks. I've heard they're expensive to use and shouldn't be used as part of a program's flow. However, in order to validate email addresses, I'm using the following code. try ...
I have one query on my page that takes at least a half second to execute using EF 3.5. When I used a stored procedure the speed was noticably faster. It is a very complex query. Will there be any performance improvements in the upcoming EF 4.0? And does EF 4.0 really beat out 3.5 performance wise? ...
I'm building a webapp using php, ajax, javascript, mysql. I've been worring about something for a while, but not sure if it's really a problem or not. Here's the basic concept of how the code is working...I would like to know if I should change it now, or if it is o.k to use as is. Performance is important to me...over 5,000 users sho...
Hi, Ive been working all day on optimizing a SQL Server 2000 db table with ~9million rows. My only db experience has been with tables with a few hundred rows, so I've never really had to deal with optimization. I am doing selects and updates based on a 21 digit number. Using an indexed char(21) type, the queries take more then 2 secon...
I have a script with a main for loop that repeats about 15k times. In this loop it queries a local MySQL database and does a SVN update on a local repository. I placed the SVN repository in a RAMdisk as before most of the time seemed to be spent reading/writing to disk. Now I have a script that runs at basically the same speed but CPU u...
Hi Guys, I'm looking for some advice to how to get the indexes running better on this query... SQL Server 2005/8 some customers have 5 some 8... SELECT sales.ChainStoreId, sales.CashBoxId, dbo.DateOnly2(sales.BonDate), MAX(sales.BonDate), SUM(sales.SumPrice) FROM [BACK_CDM_CLEAN_BOL...
Hi all Is there any deficiency performance if import a lot of name space in Web.config or in every single cs file while it's not necessary to be in all classes ? Thank you ...