Does anyone know good books that discuss the underlying architectures, in-depth analysis of CPython implementation. Something like how list / tuple / dict implemented (and performance comparison...) OOP discussion in Python context Sorry if it sounds like a silly question :( ...
I've been playing with MongoDB recently (It's AMAZINGLY FAST) using the C# driver on GitHub. Everything is working just find in my little single threaded console app I'm testing with. I'm able to add 1,000,000 documents (yes, million) in under 8 seconds running single threaded. I only get this performance if I use the connection outsi...
I am looking to improve the performance of a query which selects several columns from a table. was wondering if limiting the number of columns would have any effect on performance of the query. ...
EDIT OP has acknowledged a mistake when profiling PostgreSQL in his answer below. I am updating this question to reflect the comparison between MyISAM & InnoDB. Hello, I ran a test against MySQL InnoDB, MyISAM, and PostgreSQL to see how well each of these engines performed doing full table scans to understand what the response ti...
Which (if any) of the following will give the smallest performance hit? Or is the difference so small that I should use the most readable? In the same page I've noted 3 styles used by previous maintainers: Method 1: If (strRqMethod = "Forum" or strRqMethod = "URL" or strRqMethod = "EditURL" or strRqMethod = "EditForum") Then ... End...
If i have a view that generates multiple columns: CREATE VIEW dbo.foo AS SELECT id, SUM(SELECT [...] ) AS c1, STDEV(SELECT [...] ) AS c2, AVG(SELECT [...] ) AS c3, MIN(SELECT [...] ) AS c4, MAX(SELECT [...] ) AS c5, SUM(SELECT [...] ) AS c6, [...] COUNT(SELECT [...] ) AS cN, FROM Table GROUP BY id ...
I am using the VS Report Viewer control and stored procedures to print forms from a web application (in PDF and streamed to the client). These documents have between 1 to 200 pages, roughly, and process the same amount of rows. Not much. Any data retrieval code needs to know about business rules. For instance, there are accounts, and ac...
A recent talk about unordered_map in C++ made me realize, that I should use unordered_map for most cases where I used map before, because of the efficiency of lookup ( amortized O(1) vs. O(log n) ). Most times I use a map I use either int's or std::strings as keys, hence I've got no problems with the definition of the hash function. The ...
I have a series of NSFetchedResultsControllers powering some table views, and their performance on device was abysmal, on the order of seconds. Since it all runs on main thread, it's blocking my app at startup, which is not great. I investigated and turns out the predicate is the problem: NSPredicate *somePredicate = [NSPredicate predi...
Hi, I've a table in an Oracle (10g XE) database, and I'm going to clean it up and only keep the three recent records of each account. Here is what I'm doing right now: CREATE TABLE ACCOUNT_TRANSACTION_TMP NOLOGGING AS SELECT * FROM ACCOUNT_TRANSACTION WHERE 1=2; DECLARE CURSOR mbsacc_cur (account_id_var account_transaction.account...
Hello everybody, I've been researching a bit about .NET Performance counters, but couldn't find anything detailed (unlike the rest of the framework). My question is: Which are the most relevant performance counters to get the maximum computing power of the machine? Well, the .NET virtual machine, that is.. Thank you, Chuck Mysak ...
Are dynamic languages slower than static languages because, for example, the run-time has to check the type consistently? ...
Is it possible to move a remote inline javascript widget to the very end of my html, and then, once the DOM is ready, inject the widget inside a specific element. I see inline javascript as a candidate for poor performance. Thanks in advance. ...
I need to resample big sets of data (few hundred spectra, each containing few thousand points) using simple linear interpolation. I have created interpolation method in C# but it seems to be really slow for huge datasets. How can I improve the performance of this code? public static List<double> interpolate(IList<double> xItems, ILi...
I'm involved with a project using DotNetNuke version 05.01.04 Community Edition. We are building our new Intranet using it, but performance is terrible. We have five people adding pages and content to it and every 15-30 seconds they experience a pause of 10 seconds or longer before the system continues and the next screens loads. The s...
I am wanting to find an automated way to download an entire website page (not the entire site just a single page) and all elements on the page, then sum the size of these files. When I say files, I would like to know the total size of HTML, CSS, Images, local and remote JS files, and any CSS background images. Basically the entire page...
Is it true that we should disable etags if we are compressing with apache because the etags will be different each time? Is it true for deflate too? Thanks ...
We are using SQL Server 2005 at work and when development started it was decided that multiple databases would be created. For example, we have one database for Individual say dbIndividual and another one for Translation say dbLocale. So far this has simplified the backing up and potential restore greatly as we just need to backup what...
I have a Concept table of about 1000 rows that I would like to clear out along with all of its descendent rows in the Attribute table (There should only be one attribute row per concept). Calling save changes below takes about 2 minutes, is there any optimization I can do to the code below, or do I need to write a stored prodcedure. p...
Hey, I have a dynamic programming algorithm for Knapsack in C++. When it was implemented as a function and accessing variables passed into it, it was taking 22 seconds to run on a particular instance. When I made it the member function of my class KnapsackInstance and had it use variables that were data members of that class, it started...