Recently at my day-job were were instructed that any comments regarding our stored procedures MUST NOT exist inside the stored procedure and rather Extended Properties must be used. In the past we used something like this. /* * NOTE: Auto-Generated Procedure DO NOT MODIFY */ CREATE PROCEDURE dbo.MyProc AS SELECT * FROM MyTable GO T...
zend framework has many components/services I don't need, it has many includes. All this I think slow down application. Do you know how to speed up it? may be remove not used(what is common) components, or combine files to one file? ...
Is is possible to measure CPU per thread on a windows mobile (or CE 5) device programmatically (c++)? If not, is their a utility that will monitor the CPU usage of a process? ...
Is there any real issue - such as performance - when the hibernate object model and the database physical model no longer match? Any concerns? Should they be keep in sync? Our current system was original designed for a low number of users so not much effort was done to keep the physical and objects in sync. The developers went about ...
I'm performing a regular expression match on a column of type "character varying(256)" in postresql 8.3.3. The column currently has no indices. I'd like to improve the performance of this query if I can. Will adding an index help? Are there other things I can try to help improve performance? ...
Say I have a million-row table [mytable] in my SQL Server 2005 database, which has columns: ID SomeField AnotherField Url A very common query in this system is: select * from [mytable] where url = 'http://www.somesite.com/some/really/long/url' Which will give me better performance: a) Add an index to the Url column. or b) Add an...
We're using Pingdom to monitor our site availability and it's working well. Is there a similar service to monitor website latency? We want to make sure the site not only returns, but is running at a reasonable speed. We've made some internal test pages for monitoring, etc. but it'd be nice to have an external service to verify (especial...
We're developing web applications using DotNetNuke as a framework and our custom modules for required functionality. The problem is, that it takes a long time for the website to load when you do any changes to code. I'm looking at up to 1 minute for each restart, which really is painfully slow. This leads to very slow develop-rebuild-tes...
Just speaking to a colleague of mine. He was walking with a hop in his step, on the way to the coffee machine. I asked him "what's with the 'swarmy' walk?", he said, "I just reduced a two hour long query down to 40 seconds! It feels so good". He altered a stored procedure, that was using cursors and introduced a temp table, that was re...
What are some of the best practices in designing a JMX MBean? Any examples of ones you feel are especially useful? ...
Can someone please explain the correlation between requests per second and response time? Which are you trying to improve at first? If your competitor offers less 'requests per second' on his most used functionality then you, is your application performing better in terms of end-user performance? ...
Hello everyone, I want to have a stress/performance testing for my content management site, especially for hosted streamed video part. I am using IIS to host the videos. More specifically, I am using the new Windows Server 2008 x64 and IIS 7.0. The confusion is, I plan to write code to start a lot of threads, and in each thread I wil...
I would like a particular set of Python subprocesses to be as low-impact as possible. I'm already using nice to help limit CPU consumption. But ideally I/O would be limited as well. (If skeptical, please humor me and assume there is value in doing this; it doesn't matter how long they take to run, there can be a lot of them, and there...
Background: I have a table with 5 million address entries which I'd like to search for different fields (customer name, contact name, zip, city, phone, ...), up to 8 fields. The data is pretty stable, maximum 50 changes a day, so almost only read access. The user isn't supposed to tell me in advance what he's searching for, and I also w...
I am developing a project on windows with wamp installed using zend framework. Unfortunately it has very slow performance, although I did the things mentioned in the manual: remove require once added apc I recently installed Scienta ZF Debug Bar v1.3, and here is an example of results i get: Queries: 48 in 53.01 ms Memory: 9188...
Surely some of you have dealt with this one. It tends to happen when programmers get a bit too taken by OO and forget about performance and having a database. For an example, lets say we have an Email table and they need to be sent by this program. At start-up, it looks for anything that needs to be sent as follows: Emails = find_eve...
Ideally you want a schedule that's accommodating and flexible but when it comes to paying the bills and working in a business, that's rarely a luxury programmers have. I have been fortunate to have the grace of Steve McConnell and Frederick Brooks to tell me what to do if I want to screw up my project and I take their work seriously. A...
Hi Is there a way of finding out where my app threw an ANR (Application Not Responding). I took a look at the traces.txt file in /data and I see a trace for my application. This is what I see in the trace. DALVIK THREADS: "main" prio=5 tid=3 TIMED_WAIT | group="main" sCount=1 dsCount=0 s=0 obj=0x400143a8 | sysTid=691 nice=0 sched=0...
Scenario: over 1.5GB of text and csv files that I need to process mathematically. I tried using SQL Server Express, but loading the information, even with BULK import takes a very long time, and ideally I need to have the entire data set in memory, to reduce hard disk IO. There are over 120,000,000 records, but even when I attempt to fi...
Hi there, I've developed an Excel 2003 addin in C#, using VSTO and VS 2008. The addin works just fine on my machine (HP NC6320 laptop, 3gb RAM T5600 1.8ghz Core2 cpu), however when it is tested on another users machine (HP nc6710b laptop 2gb RAM, T7200 2ghz Core2 cpu), it is substantially slower. I've also tried it on another laptop the...