When I began, I used pg_dump with the default plain format. I was unenlightened. Research revealed to me time and file size improvements with pg_dump -Fc | gzip -9 -c > dumpfile.gz. I was enlightened. When it came time to create the database anew, # create tablespace dbname location '/SAN/dbname'; # create database dbname tablespace...
Hi All, We've got a table we use as a queue. Entries are constantly being added, and constantly being updated, and then deleted. Though we might be adding 3 entries/sec the table never grows to be more than a few hundred rows. To get entries out of table we are doing a simple select. SELECT * FROM queue_table WHERE some_id = ? ...
I am encountering a well documented issue in regards to instantiating a SoapHttpClientProtocol class. My situation is similar to the question posted here: http://stackoverflow.com/questions/172095/slow-soaphttpclientprotocol-constructor A solution to the problem can be found here: http://kb.vmware.com/selfservice/microsites/search.do...
In PHP if I create a singleton method for like 5 different caching classes (memcache, apc, session, file, cookie) Then I have a main cache class which basicly routes my set() and get() methods to the appropriate caching class. Now lets say I need to use the session, cookie, memcache, and file cache all on the same page. My main cache ...
Is there any known data structure that provides O(1) random access, without using a contiguous block of memory of size O(N) or greater? This was inspired by this answer and is being asked for curiosity's sake rather than for any specific practical use case, though it might hypothetically be useful in cases of a severely fragmented heap....
Hi, when I register a large number (10000+) of additional selectors in an Objective-C program using the runtime function sel_registerName, does this slow down my program? Not taking into account the time it takes to register those selectors. Best regards, Jochen ...
The question I have is a bit of a ethical one. I read here that Google gives a little more influence to sites that are optimized to load quickly. Obviously this makes Google's job easier, using less resources and it is a better experience for everyone, so why not reward it? The actual process of finding bottlenecks and improving page ...
I use dynatrace to find problems in my company site. I want to say,wow, this is a beautiful tool for page performance. It's another side man. But I found there are many kinds of rendering in dynatrace. For example: Calculating generic layout Calculating flow layout Scheduling layout task What's the different for these rendering? ...
I need to find all sub-arrays which share any mutual element and merge them into one sub-array. (Implementing in Python but any algorithmic idea would be helpful) Multidimensional array structure: categories = {'car':['automobile','auto'], 'bike':['vehicle','motorcycle','motorbike','automobile'], 'software':[...
I use jQuery 1.4 for AJAX, MVC on the server side. Everything works fast on the local computer. Tables with data are compiled and sent as HTML documents (I’m testing the system with large tables, over 100KB). When I download the same page through the internet, everything works 5-10 times slower or is simply pending. I checked Forefox...
I want to display a user's latest Tweets on a webpage while maintaining the ability to style the Tweets with custom CSS and also maintaining good page load speed. I have managed to display the latest Tweets in 2 ways. Using the PHP Twitter library (by Aaron Brazell). By using this method, my PHP code has to wait for a response from Tw...
Hi Anyone remembers the name of that opensource "project" that developed some nice replacement for String in java ? I know there is is one, just cant find it in google and dont remember the name. (i am not talking about StringBuilder) Thanks ...
I am working with a web page (ASP.net 3.5) that is very complicated and in certain circumstances has major performance issues. It uses Ajax (through the Telerik AjaxManager) for most of its functionality. I would like to be able to measure in some way the amounts of time for the following, for each request: On client submitting reques...
Hi all. First, I was trying to do something like : class Class1 { public void Do() { } } class Class2 { public void Do() { } } ... if (o is Class1) { Class1 c = (Class1)o; c.Do(); } if (o is Class2) { Class2 c = (Class2)o; c.Do(); } but fxcop tells me that : Performance Rules, Avoid duplicat...
Hi, I'm wondering if a 'normal' inner join leads to higher execution performance in MySQL queries than a simplistic query where you list all tables and then join them with 'and t1.t2id = t2.id' and so on .. ...
We've got a Model-View-Presenter setup with our .NET Compact Framework app. A standard CF Form is implementing the view interface, and passed into the constructor of the presenter. the presenter tells the form to show itself by calling view.Run(); the view then does a Show() on itself, and the presenter takes over again, loading up data ...
Is there a good way to record performance metrics (like number of times a function is called) for an iPhone app? I can't find any decent performance tools for it. ...
Hi, Every now and then (always after a long period of idle-time, e.g. overnight) when I access a site built using asp.net - it takes around 15 seconds to load the page (15 seconds before I see any progress whatsoever, then the page comes up fast). Further pages on that site, or refreshes, are quick as usual - they are also fast on oth...
I'm familiar with Core Data basics and have done some dabbling, but have not really done any major apps. Now I need to plan for one. And the question is not specifically about Core Data, but more about data design in general, though I am going to use Core Data to implement it on iPhone which is important for considering performance. Ima...
What would be a proper way to simulate a large number of requests to test if my web application can handle it? ...