aSymbio Developer | AJAX, Flash, Actionscript, PHP, MySQL…. the tools of the modern developer!
[Sun Sep 20 15:01:00 2009] [crit] (OS 2)The system cannot find the file specified. : Parent: Unable to connect child stdout to NUL.
[Sun Sep 20 15:01:00 2009] [crit] (OS 2)The system cannot find the file specified. : master_main: create child process failed. Exiting.
Recently I was asked to develop a website that had a product page listing of over over 20.000 products. The SELECT query to get the products was optimized as much as it could be. But it was not enough! Due to the high volume of traffic this product listings have the server was always with load over 2 (Cent OS using top). I was forced to use a simple optimization that in the end came out to be quite effective.
So even though the COUNT(*) in MySQL goes pretty fast it uses a lot of memory. This COUNT(*) was needed to find out how many products were there and display the number of pages.
Here comes the trick. The first 1,2,3,4… navigation requires 2 SQL queries to be done. The second one requires ONLY ONE.
The trick is to select one more result than you are actually showing. Let’s say that you want to display 20 results per page, you select 21. If the 21st record exists than you have a “next page” if it doesn’t you don’t.
What about the “previous page” link?
you have a previous page.
This technique is useful for high volume traffic sites where every hardware resource matters. It can not be applied on all listings due to design/functionality issues, but in some cases it could be a life saver.
The thing is that PHP5 has its own built in class soapclient and this is where the error comes from.
The solution to get NuSOAP working on PHP5 is quite simple. Open the nusoap.php file and replace soapclient with mysoapclient or whatever you think of. Use a mass find/replace if supported by your editor.
Here is a development version to how will the new Flash Photo Gallery look and feel like. The navigation is changed and the viewing is improved.
There is a download link for the current image (will be configurable in the XML file) and some other improvements. Unfortunately this version is only for preview of what is really coming so expect the official release soon.
Take a look at the Flash Gallery Development Preview Demo!
Last night I’ve put some of my ideas for the new update of Flash Gallery on paper. Here are some of them.
So, after putting this things as priorities for the development of the Flash Gallery, I think that there should be two versions of the Flash Photo Gallery, one simple for easy gallery deployment and one advanced with the web based interface.
I plan on releasing the simple one in few weeks due to some everyday work that has to be done.
A a designer I always wanted everything to be in style so when it comes to avatars I may say I have spent hours making them or simply cutting pictures to make my Skype, ICQ, MSN or some other messenger’s avatar.
-inurl:(htm|html|php) intitle:"index of" +"last modified" +"parent directory" +description +size +(wma|mp3) "madonna"
You can see the Flash Gallery demo or you can download the gallery!
IBM ThinkPad Warranty – The things I didn’t know!
Last night I accidentally tripped over my audio cable, which at the time was connected to my laptop. So I broke my audio input… When I plugged the cable in the laptop speakers were still playing and no signal was delivered to my 2.1 sound system.
Next time I will try not to leave my cable laying on the ground … finally something went wrong with my ThinkPad…. I did it! I finally succeeded in hurting it.
So, the next morning I took it to the IBM Support Center to fix the problem. They took a look at the box, asked for the warranty. After 5 minutes or something, someone from the support told me that if the laptop was spilled with watter, coffee or something else… my warranty would not matter. I will have to pay like $700.00 + something else I didn’t get.
AJAX, Flash, Actionscript, PHP, MySQL…. the tools of the modern developer!