Mysql performance and Count(*)
I want to know that my sql execute count queries in linear time or in log(n) time i think that if query parameter was indexed it can do it by cubing ...
performance
Dot net 2.0 application (Any CPU) running slow on 64bit os/processoer
Hi, My windows application is deveoped on .net 2.0 FW,and build using ANY CPU, development enviroment is 32bit OS + VS2005 Now i am deploying this application on 64bit processoer + 64bit OS it is running slow. But if i build using x86 (32bit) it is working fine without any issue on 64bit processoer + 64bit OS. I have 3rd pary comone...
Quickest way to Count the amount of numbers in a string, plus how to test PHP performance?
I need the best way of finding how many numbers in a string, would I have to first remove everything but numbers and then strlen? Also how would I go about testing the performance of a any PHP script I have written, say for speed and performance under certain conditions? UPDATE say I had to inlcude ½ half numbers, its definetly preg t...
web programming language benchmarks?
I'm thinking that as more and more programming moves to the web with similar and a variety of tools and techniques, has anyone come up with a good set of benchmarks for a programming language? I'm thinking server-side languages, like Java, PHP, ASP.net, and C# are the big ones. Though it could be anything like C or perl, I don't want t...
Mouseover/hover effect slow on IE8
I have noticed a weird performance thing in IE8 when using mouseover events on a table with many rows (100 in this example). I have tried a lot of different approaches but I can't seem to find any way to get it as fast as I like/need. If I switch classes on each event the performance goes down in all IE versions, and If I use direct man...
Drupal Performance - Sudden user burst
We run a Drupal site, and are expecting a sudden burst of users some time soon. What are some of the best Drupal practices to handle sudden burst of: - User registrations - User Authentication These operations are heavily dependent on database... so, how do we optimize that? Are there any techniques that minimize DB interaction during ...
How do SQL Server View Indexes work under the hood?
How do SQL Server View Indexes work under the hood? I've read this TechNet article but it doesn't explain how a view index actually works. Can anyone explain this to me? Note: I'm not sure if this should have gone on SF. If it should, just move it over there. ...
Why is SSE scalar sqrt(x) slower than rsqrt(x) * x?
I've been profiling some of our core math on an Intel Core Duo, and while looking at various approaches to square root I've noticed something odd: using the SSE scalar operations, it is faster to take a reciprocal square root and multiply it to get the sqrt, than it is to use the native sqrt opcode! I'm testing it with a loop something ...
SQL Server: Compare Index Performance
How can I compare the performance of an Index on a table using the Query Analyzer? I would like to run the same query through the Estimated Execution Plan twice, once using the index and once without, and have a good comparison of the table scans/index scans that are generated. I have tried CREATE INDEX..., SELECT..., DROP INDEX..., SE...
What is the performance impact of having jquery functions not used?
I posted another question on a very similar topic, but turned out to be a little subjective. I am able to divided the question in two questions, one that I will explain below: In the following Code: <script type="text/javascript"> $(function() { $("#accordion").accordion(); $("#datepicker").datepicker(); $("#button").click(f...
Large Memory Usage on Small Server (Optimization Question)
I have an application that analyzes data from input files that are generated by our core system. Depending on the client, that file can vary in size (files contain online marketing metrics such as clicks, impressions, etc..). One of our clients has a website that gets a fairly large amount of traffic, and the metric files generated are...
Performace enhancements for tables
With MySQL I often overlook some options like 'signed/unsigned' ints and 'allow null' but I'm wondering if these details could slow a web application down. Are there any notable performance differences in these situations? using a low/high range of Integer primary key 5000 rows with ids from 1 to 5000 5000 rows with ids from 20001 to...
Rendering Server side controls as string over using HtmlTextWriter
What I have? I am developing a Web Part where Client Callbacks are used. Each callback updates the page with huge volume of HTML content. What am I doing? I am creating a Table control which contains several other controls (around 500KB of static text and light image tags will be in it). I render the table using the below method: pub...
Optimize jQuery hover code to perform better (smoother animation)
Lately I've been spending some time reading about jQuery optimization tips which has certainly helped increase the performance of my scripts. However, I've got this featured news section on my site, which on mouse hover slides more information into place, and this section doesn't perform very well in any browser except Safari (and proba...
Aggregated throughput of multiple connections (Linux)
Why do multiple connections from the same host achieve better throughput than multiple connections from different hosts? I suspect is something kernel-related (Linux) but a confirmation would help a lot. More details I have 1 receiver process, let's call it R. It accepts incoming connections and receives data using select(). I have 3 ...
Difference between these connection strings?
Can anybody tell me the effective difference between the following connection strings: <add key="ConnectionString" value="server=tcp:192.168.0.12\Sqlserver2005;database=;user id=sa;password=;"> <add key="ConnectionString" value="server=192.168.0.12\Sqlserver2005;database=;user id=sa;password=;Network Library=DBMSSOCN;"> I believe b...
Tools to profile performance of .NET Compact Framework applications
The only thing I've found is EQATEC Profiler. Are there any other profilers out there that can be used to profile .NET CF apps? ...
jQuert sort function performance
I'm sorting a list of <li> elements. I adapted a function on a page that I can't link right now. You can see the live site here. Click on "Sort and Filter" and click any of the Sort by methods (English name, material, status...). All sorts are essentially the same, so CPU time is the same. My jQuery function looks like this: jQuery.fn....
Performance problem Loading Dataset inside a virtual.
Host Configuration: HP EliteBook 8530w 4G Ram Win7 Ultimate 64Bit RC SQL Server 2005 64bit Developer Edition Virtual: Windows Virtual PC 1G Ram allocated Integration Services installed Windows XP 64bit Up to date service packs and .Net framework through 3.5 SP1 Sharing the Gigabit network adapter of the Host I have a simple .Net ...
Using Repeater.ItemDataBound vs Public function. Best performance?
Hi! What is best practice and, most importantly, the method that performs best? I have a repeater where I want to manipulate the html depending on the value of the datasource. But as far as I know there are several ways to do this: Method #1: HTML: <asp:Repeater ID="rptLinks" runat="server"> <ItemTemplate> <li<%#GetLiClass...