I have a mysql database table that I want to partition by date, particularly by month & year. However, when new data is added for a new month, I don't want to need to manually update the database. When I initially create my database, I have data in Nov 09, Dec 09, Jan 10, etc. Now when February starts, I'd like a Feb 10 partition automa...
Is there any tool available by which one can calculate the size or a single row in sqlserver. This would really help in calculating the expected size of DB. Further one option can be to use sp_spaceused but it gives the details of the whole table... what we want is the size of a record (maximum size) in a table. Further is there any to...
I've noticed that the running times of my CUDA kernels are almost tripled the moment the screensaver kicks in. This happens even if it's the blank screensaver. Oddly enough, this appears to have nothing to do with the power settings. When I disable the screen saver and let the screen power off, the performance stays the same. When I set...
Hi all, I'm experiencing some performance problem using XML parser with iphone sdk. I tried to use LibXML parser directly and the NSXMLParser, but i had the same results. Now I'm looking for something that can improve parsing performance. Moving attributes to a nested elements can make it faster? I got an XML source file like this: <...
Hello, I'm building a asp.net web application with lots and lots of controls and huge volumes of data. My application is very slow and it is taking a large amount of time to load the data into the .net controls like grid, tree view etc. I also have some ajaxified pages and controls in my application. I want to reduce the page load time ...
With PHP and MySQL I am working on a user login type site. Here is my plan so far. User logs in with email/password I then set a few things into session (UserID, photoURL, userName, latitude, longitude, gender) These are the basic items that will be saved into session and possibly APC/Memcache when a user is "logged in". I have my...
I have an application written in c++ using visual studio 2005. The application has certain performance problems. I would like to explore where. I need to drill down in which classes/methods/lines the application spends most of the time. Can this be done with the WPA? If yes, can you, please give me a pointer to documentation? ...
In the Windows performance monitor tool. What's the difference between _Total and , when selecting instances for a counter? ...
I've been investigating making performance improvements on a series of procedures, and recently a colleague mentioned that he had achieved significant performance improvements when utilising an INNER JOIN in place of EXISTS. As part of the investigation as to why this might be I thought I would ask the question here. So: Can an INNER...
Hello there, i have a webapplication which performs searches on a postgresql view with about 33.000 rows. If i try this alone it takes about 1-2 seconds to get an result, which is ok i first thought. But then i downloaded the Web Application Stress Test Tool from Microsoft to give some load on my webapp. So i tried it first with 10 conc...
Given the SQL Statement: SELECT * FROM MY_TABLE WHERE SomeNumberField in (0,99999) If I can guarantee that the majority of rows in MY_TABLE have SomeNumberField set to 99999, and can project that this will remain the case indefinately, is it better to write the above query like this: SELECT * FROM MY_TABLE WHERE SomeNumberField in ...
I'm doing a "select sum(foo) from bar" query on a MySQL database that's summing up 7.3mm records and taking about 22 seconds per run. Is there a trick to speeding up sums in MySQL? ...
Hello SO, this question relates to performance penalities that may or may not arise from having a large number of sleeping python threads on a webserver. Background: I am implementing an online shop using django/satchmo. A requirement is for delayed payment. The customer can reserve a product and allow a third party to pay for it at a l...
I have a table with one DateTime column. I want to find the rows with lowest time which their times are more than a variable myTime. How can I do that? What kind of index will increase the performance? ...
here is code - (void)applicationDidFinishLaunching:(UIApplication *)application { NSBundle *bundle = [NSBundle mainBundle]; NSString *moviePath = [bundle pathForResource:@"sample_mpeg4" ofType:@"mp4"]; NSURL *movieURL = [[NSURL fileURLWithPath:moviePath] retain]; MPMoviePlayerController *moviePlayer = [[MPMoviePlayerController al...
This may be obvious to some, but I've been wondering: why should I depend on Google's server to host jQuery for my site? Is it only because it loads faster this way? ...
I have been looking into optimizing a website and specifically looking into CSS sprites, and serving static resources from a subdomain (static.mysite.com). Reference: Split Components Across Domains We are using cassini (which comes with visual studio) for development and it does not support subdomains. My static resources are contained...
In the SQLAlchemy ORM tutorial, it describes the process of creating object relations roughly as follows. Let's pretend I have a table Articles, a table Keywords, and a table Articles_Keywords which creates a many-many relationship. article = meta.Session.query(Article).filter(id=1).one() keyword1 = meta.Session.query(Keyword).filter(i...
I've trying to smooth out the performance of a map application i've been building using javascript. I initially implemented a dragging pan using onmousedown onmousemove onmouseup However in IE it feels really sluggish and it appears that when you move the cursor really fast the map doesn't update it position until you stop moving. I...
I understand there are several factors involved when making db calls and internet, but i am referring strictly to the methods processing the requests, not the roundtrip to the client. I am using stopwatch to get an average range but i do not know what is generally considered fast or decent performance. 10ms 500ms? ...