Hi. I have a database (running on postgres, precisely) , with the following structure : user1 (schema) | - cars (table) - airplanes (table, again) ... user2 | - cars - airplanes ... It's clearly not structurized the way classic relational databes should be, but it "just works" as it is now. As you can see, schemas are like prim...
Hi All, A movement is afoot in my place of employ to move away from using #temp tables and instead to use permanent physical tables with SPIDs. Whenever one would have previously INSERTed INTO a #temp table, now an INSERT INTO dbo.MyPermanentTable (SPID, ...) VALUES (@@SPID, ...) is required - together with a bunch of DELETE FROM dbo.M...
I am attempting to create a mosaic of images in Java. I calculate the size of the new image I'm creating, and then for each subimage that will be part of the mosaic, I do a paint call. In pseudocode: create buffered image big enough to hold entire mosaic create Graphics2D context from that image for each buffered subimage that will...
Hi, In C#, I often have to limit an integer value to a range of values. For example, if an application expects a percentage, an integer from a user input must not be less than zero or more than one hundred. Another example: if there are five web pages which are accessed through Request.Params["p"], I expect a value from 1 to 5, not 0 or...
In our project, we often end up writing complex joins over like 3 tables. Do we gain any performance advantages by using views or are they only for making the lives of query writers easier? In case it matters, we use MySQL. If any advantages are thus achieved (other than simpler queries of course) please illuminate. ...
As far is I know, there are a number of ways of selecting child elements in jQuery. //Store parent in a variable var $parent = $("#parent"); Method 1 (by using a scope) $(".child", $parent).show(); Method 2 (the find() method) $parent.find(".child").show(); Method 3 (For immediate children only) $parent.children(".child").sho...
I have a bunch of images to download, after their downloaded I'd like to check them against one "special" image to see if there exactly the same as this image. To do this I could just compare the arrays directly item by item or I could compute a hash and compare this. I think in this case directly comparing will be quicker, as we only d...
Hi there We're using Windows 2008 and we are thinking of switching application servers from Adobe ColdFusion 9 to Railo 3.1. This would mean using a new Java servlet container, so instead of Adobe JRun 4, we're looking at Apache Tomcat. Adobe have a helpful perfmon plugin for CF9. We can gather most stats with that. The problem is, as...
I'm running gcov (through lcov) over a medium-sized project. It's had the CPU at close to 100% for quite a while (not sure exactly how long, but over 30 minutes). The memory isn't ballooning. It seems to be stuck on one task. Is it normal for gcov to do this kind of thing? Edit No luck. Just had to exclude the piece of code that corre...
I made a javascript class that let me use gears or html5 (if available) storage to store an stringified json object. the code is ment to be use on Android 1.5 and 2.0. When I save many objects into gears, it's very slow even on a PC (google chrome / gears). The CPU doesn't go high but the page gets unresponsive for 45 sec. On a cellphone...
if I just need 2/3 columns and I query SELECT * instead of providing those columns in select query. is there any performance degradation regarding more/less I/O or memory ?? the network overhead might be present if I do select * without a need. But in a select operation does the database engine always pulls atomic tuple from the disk ?...
Now if you read the naming conventions in the MSDN for C# you will notice that it states that properties are always preferred over public and protected fields. I have even been told by some people that you should never use public or protected fields. Now I will agree I have yet to find a reason in which I need to have a public field bu...
Is there a performance gain achieved by using: SELECT Field1, Field2, Field3 ... instead of: SELECT * ... ...
Okay so i understand the basics of MAXDOP, but i want to understand if this a valid scenario for using it. I have a stored procedure which is quite resource hungry, but has been optimized to the max. It currently takes 30 minutes (local) to refresh an entire system (what is refreshes isnt really important). This procedure will get exec...
I have a program which fetches records from database (using Hibernate) and fills them in a Vector. There was an issue regarding the performance of the operation and I did a test with the Vector replaced by a HashSet. With 300000 records, the speed gain is immense - 45 mins to 2 mins! So my question is, what is causing this huge differe...
Hi, I am using the SmartOptimizer(previously named as JSmart) PHP library to improve my site performance. This library will enhance our website performance by minifying, compressing, concatenating, and caching the JS and CSS files used in our website. You can check the details of this library here. I want to use the concatenation feat...
Hello, I'm trying to implement a filecopy method that can match the performance a copy done with the windows explorer. For exemple a copy (with the windows explorer) from our nas to my computer, performs above 100mb/sec. My current implementation does the same copy at about 55mb/sec which is already better than the System.IO.File.Copy...
I'm working on a mobile version of a large site. There's a lot of content from the full site that's not needed for mobile. What is the best way to hide this? i.e. What will cause the least amount of work for the browser, so it stays responsive? CSS display:none jQuery's .remove() method, for example (not tested): var elements_to_rem...
I'm new to Python and Sqlite, so I'm sure there's a better way to do this. I have a DB with 6000 rows, where 1 column is a 14K XML string. I wanted to compress all those XML strings to make the DB smaller. Unfortunately, the script below is much, much slower than this simple command line (which takes a few seconds). sqlite3 weather.db ....
Hello, I'm using IronPython 2.6, Sharpdevelop 3.2 for GUI building and compiling, Pydev on Eclipse for writing the code and debugging. I recently had some trouble using IronPython and ListView objects. In my usecase I wanted to add ListViewItems i created in a thread very fast to an GUI ListView object. First problem I ran into was ...