Assuming I have two tables: source, and article and I wish to read article with specific details its source, I can either (1) use join for the two tables; or (2) duplicate the details to the article-record (which will make the data-unit larger, but the query will be very simple). which would be more efficient? ...
I've got a table structure that can be summarized as follows: pagegroup * pagegroupid * name has 3600 rows page * pageid * pagegroupid * data references pagegroup; has 10000 rows; can have anything between 1-700 rows per pagegroup; the data column is of type mediumtext and the column contains 100k - 200kbytes data per row userdata...
I have some relatively complex sqlite queries running in my iPhone app, and some are taking way too much time (upwards of 15 seconds). There are only 430 or so records in the database. One thing I've noticed is that opening a new database connection (which I only do once) and stepping through query results (with sqlite3_step()) causes sq...
First: I've implement a fairly complex scrolling mechanism for images, that allows to scroll over a few hundred thousands (theoretically) in one single scroll view. This is done by preloading small portions upon scrolling, while re-using all UIImageViews. Currently all I do is to assign new created UIImage objects to those re-used UIImag...
I am experiencing an enormous memory leak in my WPF project and am trying to figure out what I can do to minimize it. To access resources I use StaticResource 100% of the time. Should I use DynamicResource where I can? Are there advantages as far as memory management between StaticResource and DynamicResource? FYI: I have a listbox show...
jsc.tools.road.correctType = function() { for(row = jsc.data.selection.startX - 1; row <= jsc.data.selection.endX + 1; row++) { for(col = jsc.data.selection.startY - 1; col <= jsc.data.selection.endY + 1; col++) { if(jsc.data.cells[row-1][col].type != "road" && jsc.data.cells[row+1][col].type != "road" && jsc.data...
Hi All I have php script which calls another script with php exec function. The called script does batch process job, that is updating transaction statuses, notifies customers(puts emails to mail queue which runs separately). So it will take 20-30 minutes due to a very large table(500000 rows), Now i am running it under my desktop windo...
Does anyone know how exactly NTLM authentication works in WCF/basicHttp? I wonder if user credentials are passed for every single service method call, or if some kind of security token is being used for subsequent service method calls. The exact binding configuration that I am using: <bindings> <basicHttpBinding> <binding name="w...
This question is related to this one. I have a page table with the following structure: CREATE TABLE mydatabase.page ( pageid int(10) unsigned NOT NULL auto_increment, sourceid int(10) unsigned default NULL, number int(10) unsigned default NULL, data mediumtext, processed int(10) unsigned default NULL, PRIMARY KEY (pageid...
Or is it all about semantics? ...
I have a table which has two varchar(Max) columns Column 1 Column 2 ----------------------- URLRewitten OriginalURL its part of my url re-writing for an asp.net webforms site. when a url comes in I do a check to see if its in the table if it is i use the OriginalURL. My question is, if all I'm doing is querying the table for ...
Sometimes I hear the argument against doing things on client side using javascript. People say stuff like "JavaScript is inefficient...or slow". I'm wondering if there actual facts supporting this conclusion? ...
I have Six tables which will joined in many queries.If a View created by joining all the tables will increase the performance?.Is there are any alternatives to increase the performance?. I am using oracle as the database and all the joined columns are indexed. ...
Consider this python program: import sys lc = 0 for line in open(sys.argv[1]): lc = lc + 1 print lc, sys.argv[1] Running it on my 6GB text file, it completes in ~ 2minutes. Question: is it possible to go faster? Note that the same time is required by: wc -l myfile.txt so, I suspect the anwer to my quesion is just a plain "n...
I've asked a question about my memory management problem in WPF, but this is a different one about the same problem. I am using DotTrace trying to figure out what's going on. When I start up my app, I can see in Task Manager that it is taking 200MB. DotTrace says a total of 33MB. If I simply minimize the window and bring it back up, the ...
I was browsing some old books and found a copy of "Practical Java" by Peter Hagger. In the performance section, there is a recommendation to set object references to null when no longer needed. In Java, does setting object references to null improve performance or garbage collection efficiency? If so, in what cases is this an issue? Co...
Many of us have web and application servers that use plain TCP. Some of us have web and other servers that use a secure layer such as SSL. My understanding of SSL is that the handshaking is very computationally intensive, and the encryption of an ongoing connection is (relatively) cheap. My assumption for you to correct: an average ho...
Hi all, I had created a framework for a project in the past that one of it’s functionalities was to load the Database info into my business entity classes (only properties no methods) and from the Business entity classes to the database loading the parameters collection of the stored procedure to be executed. To this on that project I d...
If I have two queries SELECT Id, Forename, Surname FROM Person WHERE PersonName Like(‘%frank%’) And SELECT * FROM Person WHERE PersonName Like(‘%frank%’) Which query will run faster? Is the where clause / table joining the biggest factor, or the number of columns returned? I’m asking because I’m building a series of objects that m...
Hi, at an application I'm working on users can forward their email-accounts to an address from our system (something like [email protected] ). It doesn't matter here why they should do this, but I need some professional advice on the best way to approach this. The basic idea is that our mailserver receives the incoming (for...