Say for instance I'm joining on a number table to perform some operation between two dates in a subquery, like so: select n ,(select avg(col1) from table1 where timestamp between dateadd(minute, 15*n, @ArbitraryDate) and dateadd(minute, 15*(n+1), @ArbitraryDate)) from numbers whe...
I'm making an application that analyses one or more series of data using several different algorithms (agents). I came to the idea that each of these agents could be implemented as separate Python scripts which I run using either the Python C API or Boost.Python in my app. I'm a little worried about runtime overhead TBH, as I'm doing so...
On my computer at work, any time I open a file located on a network share, GVim becomes completely unusable. Scrolling through the document can take 15 seconds to go one "page". Even using the movement keys to go from one word to another can take 2 to 3 seconds. This seems to be a new behavior, but for the life of me I can't remember cha...
Our main WPF window ('Main Window') takes considerable time to create (it is using a ribbon and docking panel similar to Visual Studio). Just like in Blend the first action will always be to either choose an existing project to work on or to create a new project. Therefore we would like to show this 'Select Project' window as quickly as ...
I have a list of data that needs to be processed. The way it works right now is this: A user clicks a process button. The PHP code takes the first item that needs to be processed, takes 15-25 secs to process it, moves on to the next item, and so on. This takes way too long. What I'd like instead is that: The user clicks the proces...
Hello, I generate a list of one dimensional numpy arrays in a loop and later convert this list to a 2d numpy array. I would've preallocated a 2d numpy array if i knew the number of items ahead of time, but I don't, therefore I put everything in a list. The mock up is below: >>> list_of_arrays = map(lambda x: x*ones(2), range(5)) >>> l...
I have an integer "myInt" in some Objective-C code. myInt is used as a boolean... hence I'm only interested in zero or non-zero values. I'd like to quickly switch between zero and a non-zero value. What's the fastest way to do this? Here's what I've tried so far: (All of these work) Try 1: // myInt is initialized to 0 if(myInt =...
Hi.. Has anybody implemented the PerformanceTestCase provided by android and got some results...If you have done it please provide some source code,it will be really helpful... Here is the android link: http://developer.android.com/reference/android/test/PerformanceTestCase.html I have used the traceview tool but I need results like CP...
If i were to organise data on tourism and hotel for the continent of Australia and south America can you let me know a best way to do it. Like if i organise the tables thus: continents countries states zipcodes cities destinations hotels lnkhotelszipcodes (in case a hotel exists in multiple places) lnkhotelscities It will be search ...
i have a problem regarding vs 2008, that it is very very very slow, hangs, even if i type "=" building process is not that bad but lagging too much while programing my system specs are 4gb ram 2.0 c2d 1 gb grahpic card vista 64 Can somebody tell me solution for this i have installed visual assist and i have also tried to disable it bu...
Should I use UIImage or CGImage ? Png or Jpg ? I've read the doc and tried different things but did not notice significant improvement. Loading an image can take 1 good second which seems slow ...
The last three of these method calls take approx. double the time than the first four. The only difference is that their arguments doesn't fit in integer anymore. But should this matter? The parameter is declared to be long, so it should use long for calculation anyway. Does the modulo operation use another algorithm for numbers>maxint...
Hi, We're trying to measure performance of our system, which is a .NET 3.5 application that uses WCF calls. Problem is until now, we weren't able to profile the methods inside these calls. A winforms client application was coded to test our system. We tried using ANTS 4 Profiler and VS2008 built-in Performance Analyzer, but we only got...
When Using SQL Server Reporting Services (client Reports), whenever a Client (rdlc) report Opens Visual Studio Loads entire application datasets, how to speedup loading this all datasets or how to change the process to only load specific Dataset to use in Report ? ...
We have a Large-scale Application and it have dozens of resx file to localize application these files build each time and take much time to build and the build process goes longer how to remove these kind of files from build process ...
Hi, I have a Excel COM addin which reads the CustomDocumentProperties section of a workbook. This is how I access a particular entry from the CustomDocumentProperties section DocumentProperties docProperties = (DocumentProperties) xlWorkbook.CustomDocumentProperties; docProperty = docProperties[propNam...
I am looking for information about how SQL Server actually handles query execution in finer details (like what data is kept in buffer/memory and how does it decide to get fresh data even if there is an update change in only one column of a table involved in a query etc) If anyone knows sources please let me know? We have an web appli...
I have a class which doesn't currently need to be thread-safe, but in future we might want to make a thread-safe version. The way I see it, I can either make it thread-safe now by putting locks around the relevant functions, or I can make them virtual now and put locks around them in overrides in a descendent class later on. That is, t...
Which is faster? SELECT UserName FROM dbo.UserTable WHERE UserID in (1,3,4) SELECT UserName FROM dbo.UserTable WHERE UserID = 1 OR UserID = 3 OR UserID = 4 ...
I have written a set of acceptance tests, and am trying to test the performance of a library with them. Unfortunately, I can only seem to select a single test and "Create Performance Session" ...which doesn't give a true picture of performance of the app as a whole. Is there a way to get a performance report of all the tests at once? ...