Hello, I am trying to get serialized results from a WCF service from database using linq. The tables in the db are normalized to some extent and I'm returning some other data along with the on that I initially retrieve with a linq query using Data.Linq.DataLoadOptions, just like in Scott Landford's Blog: http://codeexperiment.com/post...
Hi, here's a six core with 32GB ram. I've nginx 0.7.X and php5-fpm with php5.3 (from dotdeb.org). Important config files: nginx.conf user www-data; worker_processes 2; events { worker_connections 4096; } location ~ \.php$ { fastcgi_pass unix:/tmp/fcgi.sock; fastcgi_index index.php; ...
I want get n-th to m-th records in a table, what's best choice in 2 below solutions: Solution 1: SELECT * FROM Table WHERE ID >= n AND ID <= n Solution 2: SELECT * FROM (SELECT *, ROW_NUMBER() OVER (ORDER BY ID) AS row FROM Table )a WHERE row >...
Hello togehter, what are the performance aspects if you have something like this in your query: ... AND x.somfield IN ( 33620,262,394,450,673,674,675,2331,2370,2903,4191,4687,5153,6776,6898,6899,7127,7217,7225, 7227,7757,8830,8889,8999,9036,9284,9381,9382,9411,9412,9423,10088,10089,10304,10333,10515, 10527,10596,106...
I need to draw a few hundred lines and circles on my view and they keep moving through a timer function, where I call [myView setNeedsDisplay] to update the view. I subclass (myView) from UIView and implement drawRect function to do the following ... -(void) drawRect:(CGRect)rect { CGContextRef context = UIGraphicsGetCurrentContext(...
I have a situation where I would like to search single word. For that scenario, which Query would be good from performance point of view? Select Col1, Col2 from Table Where Col1 Like '%Search%' Or Select Col1, Col2 from Table Where Col1 CONTAINS(Col1,'Search') ...
I see the following in the logback documentation: Generating the line number information is not particularly fast. Thus, its use should be avoided unless execution speed is not an issue. There are similar warning for method name, calling class, etc. It would be very helpful to get line number and method information in our logs whe...
Hi experts, I am trying to find memory leaks from my Xcode project. I don't know, what happened - I can't select anything from Run->Run with performance tool - the list of things are disabled. Please help me, I am a beginner. ...
I have already read the hibernate docs about concurrency and I think, I have understood the available locking methods, but I am not sure how I should implement the following scenario. Two clients F (fast) and S (slow) access the database and can modify the same objects. Now, one additional requirement: It is critical to the application...
Hello, excuse my english First of all, I am new to optimizing mysql. The fact is that I have in my web application (around 400 queries per second), a query that uses a GROUP BY that i can´t avoid and that is the cause of creating temporary tables. My configuration was: max_heap_table_size = 16M tmp_table_size = 32M The result: temp ...
I have some very large (>4 GB) files containing (millions of) fixed-length binary records. I want to (efficiently) join them to records in other files by writing pointers (i.e. 64-bit record numbers) into those records at specific offsets. To elaborate, I have a pair of lists of (key, record number) tuples sorted by key for each join I ...
I'm writing a web site with rails, which can let visitors inputing some domains and check if they had been regiestered. When user clicked "Submit" button, my web site will try to post some data to another web site, and read the result back. But that website is slow for me, each request need 2 or 3 seconds. So I'm worried about the perfo...
Given two numbers a, b such that 1 <= a , b <= 10000000000 (10^10). My problem is to check whether the digits in them are permutation of each other or not. What is the fastest way of doing it? I was thinks of using hashing but unable to find any suitable hash function. Any suggestions? For e.g - 123 is a valid permutation of 312 A...
How do I maximize performance for my wcf service? Is it possible to take advantage of multicore? or multi-threading? Thanks!! ...
For a normal app, you'd never want to do this. But ... I'm making an educational app to show people exactly what happens with the different threading models on different iPhone hardware and OS level. OS 4 has radically changed the different models (IME: lots of existing code DOES NOT WORK when run on OS 4). I'm writing an interactive t...
Hi, My project has a module which generates crl for revoked x509 certificates. However, the crl generation api provided by bouncy castle is fully 'memory' dependent and I don't think it will scale after some point in time. I also know that crl can be generated as deltas or in partitions. But is there an api which can generate crl witho...
Will Mssql be even fast when I query on a view opposed to one query? example When I have this view: create view ViewInvoicesWithCustomersName Select * from Invoices left join Customer on Customer.ID=Invoices.CustomerID What will be faster or will it be even fast? a) select * from ViewInvoicesWithCustomersName where customerName="B...
Consider the following code (from here, with the number of tests increased): from timeit import Timer def find_invpow(x,n): """Finds the integer component of the n'th root of x, an integer such that y ** n <= x < (y + 1) ** n. """ high = 1 while high ** n < x: high *= 2 low = high/2 while low < high:...
Greetings. I have a .NET application running a bunch of simulations in parallel. It's doing a parameter sweep, so each parameter has its own Parallel.Foreach loop. I normally set the max parallelism to one in all but one of loops, to keep memory requirements down, since each parameter can take more values than I have cores available (4)...
This code takes timings for n invocations of two methods that both do nothing (MyMethod1, MyMethod2) but are decorated with different attributes (MyAspect1, MyAspect2). MyAspect1 contains no logic apart from letting MyMethod1 run (Proceed()). MyAspect2 does the same for MyMethod2, but also creates a Task, supplying an anonymous deleg...