Hi all! I'd like to optimize my queries so i look into mysql-slow.log. Most of my slow queries contains ORDER BY RAND(). I cannot find a real solution to resolve this problem. Theres is a possible solution at MySQLPerformanceBlog but i don't think this is enough. On poorly optimized (or frequently updated, user managed) tables it doesn...
I'm trying to show a small loading image during a slow operation with jQuery and can't get it right. It's a BIG table with thousands of rows. When I check the "mostrarArticulosDeReferencia" checkbox it removes the "hidden" class from these rows. This operation takes a couple of seconds and I want to give some feedback. "loading" is a di...
Hi All, I have one procedure which retrieves all the records from one table which has more than 20000 records and two columns. the column i m trying to retrieve has the index on it. But still it takes more than 1-2 minutes to execute. Can anyone provide any input on this. ...
We recently had an issue I'd never seen before, where, for about 3 hours, one of our Mysql tables got extremely slow. This table holds forum posts, and currently has about one million rows in it. The query that became slow was a very common one in our application: SELECT * FROM `posts` WHERE (`posts`.forum_id = 1) ORDER BY posts.crea...
I have created a Windows Form App for Managed Care(CRUD of Member Data). It is an internal app that uses Merge Replication to allow field use. The app basically follows this structure: Form Shell Form MemberHost Form Member Form MemberContacts Form MemberInsurance Form Enrollments Form CaseNotes Form MemberCenteredPlanHost Form M...
Hi Guys, I have a UitableView with a custom UitableViewCell. The problem I am having at the moment is really slow scrolling performance. It's not really noticeable on the 3g iPhone but all previous iPhones are really slow. I have a requirement to display dynamic data in a tableView Cell, this data can be customised in the Stored Proced...
We have a project for a client that is written in VB.NET. In one of the projects, we have about 100 modules, which are all VERY simple. They're extension methods that convert between object types. Here is a small snippet: Public Module ScheduleExtensions <System.Runtime.CompilerServices.Extension()> _ Public Function ToServicesData(ByV...
I am getting extremely slow load times and before any action is taken I was wondering if there was an easy way to test to see if it is because of the ISP or the coding of the site. We currently have a T1 going to two mirrored servers, so I don't think the ISP is the issues, we only have a few users on at a time. The website is: http://...
I'm writing an application that does a lot of batch printing, but each print is taking several seconds to complete. I've tracked it down to the getter of property PageSettings.PrintableArea in System.Drawing.Printing - each call to that takes over one seconds to finish! Can anyone shed any light onto why this is, and also how it can be ...
I'm trying to fine-tune my MySQL server so i check my settings, analyzing slow-query log, simplify my queries if possible. Sometimes enough if i indexing correctly sometimes not. I've read somewhere (pls correct me if this is stupidity) more indexes than i needed make the same effect like i haven't any of them. How many indexes are eno...
I tried air for a few applications such as tweetdeck, ebay, however they are prohibitively slow, I'm using a ubuntu 8.04 system. Is this a common issue ? In my first thought, AIR should be faster than web-browsing, AIR only need to get the "data", and locally store the "format" the dynamic effects are taken care of by FLEX rather th...
Hi, I have a query in MySQL (used in a stored procedure) which searches by name and another field. When I use different combinations of these search parameters, I get quick results (between 1 and 2s) but with some particular values, I get a query which takes 9s to return results on the production website. The following is what I got out...
I use jdbc to connect to mysql, when it is at localhost:3306, everything is OK. but when i move my application to another computer in the intranet, and use Intranet-IP:3306 to connect to mysql database, it will consume around 1 minutes to connect to mysql successfully. what's up ???? Thanks in advance ! ...
Hi, I have a query in a large MySQL table (>4 million rows). This query is used in a stored procedure and it searches by surname and another numeric field. When I use different combinations of these search parameters, I get quick results (between 1 and 2s) but with some particular values, I get a query which takes 9s to return results o...
I have a few reports of people seeing raw html in their browser (instead of their browser interpreting it). It seems to be happen on slow connections. When this happens, if the user reloads the page, the page is interpreted correctly. Are there any html specific things that would cause this to happen (as opposed to server settings)? ...
I'm using Aptana Studio on a PHP project and as with many other people I find the file save takes a lot of cpu effort. On my Mac at work, the 2 CPUs run up to 70-80% each and activity monitor reports Eclipse at 99.5% (i.e. 1 cpu of the two). However my PC at home has 4 CPU and on save Task Manager shows Aptana pegged at 25% (ie 1 cpu o...
I'm playing around with the IMAP protocol in PHP using fsockopen to send and receive commands. My preliminary experiments work but are insanely slow. It takes about 2 minutes for the simple function below to run. I've tried several different IMAP servers and have gotten the same result. Can anyone tell me why this code is so slow? <?php...
What's up people. Something's been bothering me for a while now... and I was wondering if any of you might know of a workaround for this. The C# solution im working on is a huge solution that contains about 20 projects and almost the same amount of unit test projects. Each projects contains hundreds of files. So opening and closing the...
I've been wracking my brains out trying to figure out what the heck is going on with the most recent (non beta) Visual Studio 2008 SP1: My app built with OpenMP runs incredibly slow in the debugger, bringing CPU usage to 100%. When they are run outside the debugger, it merely runs slowly (for a release build). My app built with the Int...
I am writing a windows application with C# in visual studio .net 2005. In the form , there are some control with transparent Background; the form opens maximised and with full screen background. The application runs very slow with high CPU usage. Why is this? ...