I need to test the performance of application running on localhost as if it were in the online environment. I mean the performance test conducted by the network traffic simulation, limited bandwidth simulation, or other parameter as if it were online. could Apache Ab do the simulation? Thank u so much. ...
I have three tables: SmallTable (id int, flag1 bit, flag2 bit) JoinTable (SmallTableID int, BigTableID int) BigTable (id int, text1 nvarchar(100), otherstuff...) SmallTable has, at most, a few dozen records. BigTable has a few million, and is actually a view that UNIONS a table in this database with a table in another databas...
Occassionally I need to check for duplicate IDs in a set of values and generally I use a Dictionary for this - using just the keys and leaving values empty. Note that this is tight and highly optimized code so please no cries of 'premature optimization'! Assuming scenarios where CPU and RAM are being squeezed to the limit I was wanting...
My latest idea for do settings across my php project I am building was to store all my settings in a config PHP file, the php file will just return an array like this... <?php /** * @Filename app-config.php * @description Array to return to our config class */ return array( 'db_host' => 'localhost', 'db_name' => 'socialnetwor...
Not long ago I was playing around with GETEXT in PHP for language files and doing a lot of research on the best way to offer multilingual support in a PHP app, it seems the general consensus was to use GETEXT instead of arrays or constants or any of the other options. I often look over big name projects code like wordpress, vbulletin...
I have read many articles about linq to sql performance. The result which i got is it is slower than normal approach(DAL or Microsoft Enterprise library). Slower for both read and write operations even after performance tuning like disable ObjectTracking and other tricks. I know it has prons like quick development, clean code etc but wha...
$categories = array("google","adobe","microsoft","exoot","yahoo"); $sql='google,exoot,adobe';//from mysql_query $categs = explode(",",$sql); for($x=0;$x<count($categs);$x++){ for($y=0;$y<count($categories);$y++){ if($categs[$x] == $categories[$y]){ $str .= $y.","; } } } echo str; // 0,3,1, Will thi...
Hi all, I am trying to benchmark a piece of software that runs on an Intel Pentium with Linux on top of it. The problem is, that I get considerable performance variations during consecutive test runs, when using the RDTSC instruction. Runtimes of exactly the same piece of software vary between 5 million and 10 million clock cycles, so i...
begin transaction; create table person_id(person_id integer primary key); insert into person_id values(1); ... snip ... insert into person_id values(50000); commit; This code takes about 0.9 seconds on my machine and creates a db file taking up 392K. These numbers become 1.4 seconds and 864K if I change the second line to create table ...
suppose that I have a table with 10000000 record. What is difference between this two solution? 1- delete data like : DELETE FROM MyTable 2- delete all of data with a application row by row : DELETE FROM MyTable WHERE ID = @SelectedID Is the first solution has best performance? what is the impact on log and performance? ...
Hi Guys, I have a php script, I use it to be run in as cron job. When this script running it takes about 13 minutes on 16000 user records. Please advice me to make this script running with the best performance. I need to know that if there is any problem if i put update then insert inside a loop, or insert then update inside a loop. ...
Hi, I have a query joining 4 tables with a lot of conditions in the WHERE clause. The query also includes ORDER BY clause on a numeric column. It takes 6 seconds to return which is too long and I need to speed it up. Surprisingly I found that if I remove the ORDER BY clause it takes 2 seconds. Why the order by makes so massive difference...
Hi, I have a Core Data based iPhone application that needs to save 1000 managed objects on termination. This takes 8+ seconds, however, the OS kills the app if it does not complete in approx. 6 seconds. I don't want to save the objects earlier, because then the user has to wait 8 seconds longer for the results to display. Is it possib...
Suppose I have a page called mysql_query_performance.php which contains code to select some records from table and echo it. But I want to know how can I simulate more than 1 request to test the performance of that query? Is this Possible? If yes, How? ...
I have a few scripts that use jQuery, and I think I have a memory leak in one of them. How one could profile and find what parts of the scripts that I have are using the most memory/CPU? Thanks ...
In terms of memory and time, is it better to make a method static? ...
i was trying running application with instrument tool. but it collects so many data. so i am confuse where to look exactly in order to optimize my app. is there any best start up guide or any best practice. hope my question is genuine and clear. Edit: attaching sample image from instrument.how to interpret this data. click here for fu...
Working in Matlab I have 2 vectors of x coordinate with different length. For example: xm = [15 20 24 25 26 35 81 84 93]; xn = [14 22 26 51 55 59 70 75 89 96]; I need to map xm to xn, or in other words to find which coordinates in xn are closest to xm. So if I have values associated with those coordinates, I can use this map as index ...
I'm using the Qt graphics API to display layers in some GIS software. Each layer is a group, containing graphic primitives. I have a performance issue when loading fairly large data sets, for example this is what happens when making a group composed of ~96k circular paths (points from a shapefile): The complete callgrind dump is here...
I need to present performance test tool to management team of my company. Some of them think performance testing is not necessary for us because our customer never request or give requirement about performance to us. However one of our current big project found performance problem, responding time is very long, server down when it handl...