When you start perfmon*, it loads running 3 counters: Memory "Pages/sec", Physical Disk "Disk Queue length" and Processor "% Processor Time". How can I change that to be counters I care about? *To start perfmon, either type "perfmon" at a command prompt or under "Administrative Tools" select "Performance" ...
I have a read only database (product) that recides on its own Sql Server 2008. I already optimized queries by looking at most expensive queries in activity monitor - report. I ordered the report by CPU-cost. I now have something like 50 queries/second and no query is longer than 300ms. CPU-Time is ok (30%) and Memory is only used by 20...
Can you guys give me opinion on these scenario: 1. data list is large and update quite often 2. data list is small and does not update that often 3. any other interesting case that you guys think a noob like me should know ...
Which is the best: create the modules and put them in a separate file and import them or put them all together in the same file? Is there any significant difference? ...
My bookmarks.html file is 40 MB in size. Anytime I edit a bookmark in Bookmark Manager (Firefox), I find myself waiting 10-20 seconds for the operation to complete. (Looking at the Activity Monitor, I can see there is a lot of disk activity). Q: How can I tell my OS to specifically cache the file "bookmarks.html" (so that read/write o...
What challenges in shared memory parallel programming (particularly multicore) cannot be solved or cannot be solved efficiently using a Cilk-style solution (i.e. nested data parallelism with per-core work stealing task deques)? ...
I have a table of 50 odd rows with 11 columns. Each row has a unique id made up of id="row_<clientid>_rownumber". There is a checkbox in the second column with id="group_<clientid>_<petid>_rownumber" When the user clicks a checkbox I want to remove all rows except any that belong to the selected client. I have code that works as follo...
The following SQL takes 62 seconds to return: select getCreditBalance(Customerid) from business_apply where serialno = '20101013000005' How to tune it? Please tell me in detail. I just want to know the steps I should do to tune it . we use IDS 9.04 . As in JDBC I cant see output with SET Explain ON shall I execute query in dbac...
For university I benchmark the influence of certain refactorings (e.g., inline class and replace inheritance with delegation) on performance. Although I use HotSpot 5 and 6 in interpreted mode (-Xint), the differences in performance between the refactored and the not refactored versions are very small (few milliseconds at best). Therefo...
Hello, We are a company, working on small and some huge project. Sometimes on one project are more developers 5, 10, 20 etc. We are searching for an effective revision control system with best optional properties: Performance issues – one file size, complex directory structure Scalability – support for 5, 10, 25 developers, 10, 50, ...
Let's say that I need to make a mapping from String to an integer. The integers are unique and form a continuous range starting from 0. That is: Hello -> 0 World -> 1 Foo -> 2 Bar -> 3 Spam -> 4 Eggs -> 5 etc. There are at least two straightforward ways to do it. With a hashmap: HashMap<String, Integer> map = ... int integer = ...
I want to delete about 90% of rows from a million+ row table. Anything I can do to make this faster? e.g. if I turn on Simple Recovery Mode will this help? ...
Hi, I want to connect to about 9 databases and create an instance for everyone of them to aggregate my results in the queries. I am writing a metrics dashboard for my company that need to track results and performance over about 9 different databases with about 15mil+ records in each. Now the technical part is not hard. I know how to c...
I have to log slow queries , let's say queries which takes more than 3ms to run should be logged Most of the times these queries are SELECT how to log them in Oracle ? ...
Hi, I have been using the DataTables plugin for jQuery (http://www.datatables.net) to search, sort and paginate tabular data on the client. The simplicity of implementation and smooth user experience have been a huge win. Now I have a requirement to implement the same functionality (search, sort, paginate) over a larger set of data, ma...
Hello Everyone, I am looking for a free or paid (the best in the market you know of) benchmark/performance tools for Android based smart phones hardware. Basically I need some tools to test the performance of CPU, Memory, Graphics etc.. Any help will be appreciated. ...
I have a table in SQL Server 2008 R2 consisting of about 400 rows (pretty much nothing) - it has a clustered index on the primary key (which is an identity). The table is referenced via referential integrity (no cascade delete or update) by about 13 other tables. Inserts/Updates/Gets are almost instant - we're talking a split second (a...
Hello. I'm currently working on implementing a fuzzy search for a terminology web service and I'm looking for suggestions on how I might improve the current implementation. It's too much code to share, but I think an explanation might suffice to prompt thoughtful suggestions. I realize it's a lot to read but I'd appreciate any help. Fi...
On a standard LAMP stack, do .php files without any PHP in them get passed to the PHP interpreter? In other words, is there a performance/processing loss for creating a .php file without actually including any PHP in it, versus just making it a .html file? ...
I've got a problem with performance of my reporting database (tables have millions of records, 50+), when I want to calculate distinct on column that indicates a visitor uniqueness, let's say some hashkey. For example: I have these columns: hashkey, name, surname, visit_datetime, site, gender, etc... I need to get distinct in time spa...