So I have a fairly hefty cube that won't be much good without aggregations. I'm still in dev phases, so I'm manually attempting usage based agg design. I'm aggregating some of the main queries that we've designed. However, every time I pull these up, it looks like it's reading through each partition it hits (biggest groups are partitione...
From your experience, is it better to use 1 language file or multiple smaller langauge files for each language in a PHP project using the gettext extension? I am not even sure if it is possible to use multiple files, it is hard for me to test since the server caches the language files. I am doing multiple languages on a social networ...
PHP is interpreted. JSPs are compiled. Yet the PHP interpreter seems tightly coupled with Apache (using mod_php). The JSPs are compiled, but it's bytecode...yet the java runtime is highly optimized...yet there is the Tomcat container and mod_jk sitting in between Apache and the runtime. Lots of things to consider, of course. Has anyone ...
What is the fastest built-in comparison-method for string-types in C#? I don't mind about the typographic meaning here it's only for use in sortedLists and stuff like that to search fast in large collections. I think there are only two methods: Compare and CompareOrdinal. What's the fastest? The second question is if there is a faster m...
Hey everyone, I was wondering if anyone could point me in the direction of some good resources (web sites, technical articles/journals, books, etc.) related to database monitoring/performance? I am looking to write a paper that explores what kinds of statistics are useful in database monitoring, and to whom they are useful for. So, I...
How do you efficiently transpose a matrix? Are there libraries for this, or what algorithm would you use? E.g.: short src[W*H] = { {1,2,3}, {4,5,6} }; short dest[W*H]; rotate_90_clockwise(dest,src,W,H); //<-- magic in here, no need for in-place //dest is now: { {4, 1}, {5, 2}, {6, 3} }; (In my specific case its src arr...
I am building a system for my client. Its a lot like www.getafreelancer.com. There are 2 types of user: Service Provider and Service Buyer. Service Buyers post projects. Service Providers are notified of any new projects posted, which fit into their classifications. Assume: There are approx 100 qualifications. Service Provider can choos...
Updated: ================================================================ I finally found the reason with oprofile. It was because the routing cache of Symfony. We have lots of pages with different urls and symfony caches them in one file (serialized data). So the cache file grows large and it needs more CPU to serialize and unserialize...
I have a Web Application deployed to a local Glassfish server which I would like to profile in order to see which parts of my code is accessed most frequently. The code consists of JSF beans and Remote EJBs, with both being deployed in a single EAR. I tried using VisualVM to profile my Application but, although I can successfully connect...
Which is the fastest javascript engine? Does it really matter? ...
I'm doing some work on a Complex Event Processing system. It supports filtering of sets of records based on members of those records, using a query language. The language supports logical, arithmetic and user-defined operators over arbitrary members. Here's an example of a supported query: ( MemberA > MemberB ) && ( @in MemberC { "str...
Performance wise, I was wondering which method of defining constants/settings is better? Using a config.ini file through a class like Zend_Config_Ini or just defining a series of php constants? ...
I'm currently working on a very large Flash platformer game (hundreds of classes) and dealing with an issue where the game slowly grinds to a halt if you leave it on for long enough. I didn't write the game and so I'm only vaguely familiar with its internals. Some of the mysterious symptoms include, The game will run fine for a determi...
From a performance standpoint, does the order of my SQL WHERE statements make a difference? For instance SELECT ... FROM ... WHERE a > 1 AND b < 2 Would that be any faster/slower than SELECT ... FROM ... WHERE b < 2 AND a > 1 Let's also assume that I know in advance that a > 1 will narrow the result set the most. Also, does it ma...
I need to generate a large list of random numbers from 600k to 2000k, but the list can not have duplicates. My current 'implementation' looks like this: <?php header('Content-type: text/plain'); $startTime = microtime(true); $used = array(); for ($i=0; $i < 600000; ) { $random = mt_rand(); //if (!in_arr...
I'm building a very slimmed down website. And I would like to know what I can do, to improve performance as much as possible. The site should do something like, fetch a header from the request. make an asynchronous SOAP call. redirect the request to another server. To be able to do this I also need to be able to use the cache. So! W...
We have a table with a composite Primary key consisting of three fields (and it is in MySQL 5.1). There are near 200 inserts and 200 selects per second on this table, and the size of the table is around 1 million rows and it is increasing. My question is, does the "Composite Primary Key" decrease the performance of the Inserts and Select...
I need to get some info passed as a lambda expression to some methods. Basically, it's a way to add information to a database query. A simple example would be: companyData.GetAll( where => "SomeField = @SOMEFIELD", order => "Id", SOMEFIELD => new Parameter {DbType = DbType.String, Value = "some value"} ) It's working pretty w...
I'm using a version of SQL Server 2005 that does not support the profiler, trying to figure out how best to compare the performance of two stored procedures. I've run the execution plan for each, but it's not clear to me which of the provided metrics I should be focusing on. Do I go through and add up the various costs? What's the bes...
I have this python cgi script that checks if it hasn't been accessed to many times from the same IP, and if everything is ok, reads a big file form disk (11MB) and then returns it as a download. It works,but performance sucks. The bottleneck seems to be reading this huge file over and over: def download_demo(): """ Returns the...