I did some operations on my tables to get faster SP operations against to time-out problem on a web service method which uses that problematic SP. I was trying to compare SP perfomance but i could not get on well on that sie. See 1 please. Clearly, I want to see if I get time-out problem after all SP modifications on development scope....
What is the best way to launch an app and calculate its launch time in android(if it can be done with some code,then its better) ...
Sometimes we can write a query with both derived table and temporary table. my question is that which one is better? why? ...
Which of the following code snippets performs fastest? if(ClassTestBase is ClassTestChild1) or if(ClassTestBase.Type == EClassType.Child1) Update: Here is the full scenario: public enum EInheritanceTree { BaseClass, Child1, Child2, Child3 } public class MyBaseClass { public virtual EInheritanceTree MyClassTy...
Is there any reflection performance considerations when repeatedly calling container.Resolve<T>() when a resolution has already been established? I'm using it in an MVC controller to resolve my data service, so it will be called on every HTTP request. I'm storing the container instance in Application state, and I'm using container contr...
Hi, I downloaded the AOL Pagetest tool from http://sourceforge.net/apps/mediawiki/pagetest/files, and opened it from IE8. When I try to go to a page in IE I get the following error: (this is from the Load details tab) Results for 'Data Transmitted': Error loading page: 99997 (0x0001869D) Page load time: 0.000 seconds Time to first byte:...
I have a query that joins two tables. One table has a column that is of type varchar, and the other table has type of number. I have executed my query on 3 oracle databases, and am seeing some strange results I hope can be explained. On two of the databases something like the following works. select a.col1, b.somecol from tableA a i...
There's a lot of buzz about MooseX::Method::Signatures and even before that, modules such as Params::Validate that are designed to type check every argument to methods or functions. I'm considering using the former for all my future Perl code, both personal and at my place of work. But I'm not sure if it's worth the effort. I'm thinking...
I currently have a Python application where newline-terminated ASCII strings are being transmitted to me via a TCP/IP socket. I have a high data rate of these strings and I need to parse them as quickly as possible. Currently, the strings are being transmitted as CSV and if the data rate is high enough, my Python application starts to ...
I have a simple program that breaks a dataset (a CSV file) into 4 chunks, reads each chunk in, does some calculations, and then appends the output together. Think of it as a simple map-reduce operation. Processing a single chunk uses about 1GB of memory. I'm running the program on a quad core PC, with 4GB of ram, running Windows XP. ...
I am profiling a networking workload application on Windows XP. The VTune profiling result shows unusual high utilization on ntkrnlpa:FsRtlAreNamesEqual and ntkrnlpa:RtlUpcaseUnicodeString functions. From the module level, the workload spends 73% cpu time in ntkrnlpa.exe. In ntkrnlpa.exe module, 42% time is spent in FsRtlAreNamesEqual fu...
Hi, I have a database that stores dates broken into int's. I.e. Day, Month and Year are stored separately in different columns. In existing SQL queries, the method used is: DATEADD(dd, - 1, DATEADD(mm, Z.LastMonth, DATEADD(yy, Z.LastYear - 1900, 0))) AS last_date I cannot change the database to store dates instead. Looking further i...
I've been using Shark to benchmark a (very large) application and have a set of features I drill down into each time (e.g., focus on one function and remove stacks with particular others to determine the milliseconds for a particular feature on that run). So far, so good. I'd like to write a script that takes in a bunch of shark session...
I'd like to know if anyone tried new .NET 4.0 Memory Mapped Files features? I know that they are as old as OS but native handling in .NET is new. Has anyone been able to test this and say something about performance? I'm quite interested in access time to random parts of binary file, write speed and so on. Also performance comparsion ...
If I have say for example 100,000 rows to insert/update/delete, and this number will grow constantly. Which of the following is the best approach, or does it not make any difference. The PeopleRepository AddPeople implementation public void AddPeople(IEnumerable i) { _Database.people.InsertAllOnSubmit(i); } The PeopleRepository A...
How to enable persistent SMTP connections in PHPMailer? I will send many emails, so with persistent connections probably I will get performance gain. ...
Is it more performant to use a Prepared Statement with one question mark in it fifty times, or to use a Prepared Statement with fifty question marks in it once? Essentially is Where Person = ? or Where Person IN (?, ?, ?, ...) better? Example Say you have a table with a column, country, and then a few relational tables away you have t...
We are using Apache Velocity for website templates and some of them are getting complex. Have you noticed any performance issues with certain Velocity features? And how did you get around them? ...
We have a simple flex game. And I want to keep my FPS constantly. Now I use: (new Date()).getTime(); It's OK in windows and it's OK in flashplayer on Mac and Linux. But in browsers in Mac and Linux this method is too slow. What can I use instead? ...
I've got this script that runs on a SQL Server Express 2008 machine. /* BUD501T */ declare @ErrMsg nvarchar(4000) declare @ErrLine nvarchar(100) declare @currentFY nvarchar(1000) declare @programName nvarchar(1000) set @ErrMsg = '' set @ErrLine = '' set @programName = 'BUDPROD - GL_Exp.sql' select @currentFY = value from Budget...