Monday, July 23, 2012

BlackBerry App World Wireless problem solved

popular blackberryProblem
In blackberry , we can use the browser with no problem but when we go to use blackberry app world it uses the mobile network internet , so  do we fix that.


when you try to connect the blackberry app using wireless app world , it says 
"You do not have sufficient wireless coverage or your connection to the wireless network is turned off"


Solution:
You need a BB(blackberry) data plan, as you can't use app-world without a BB data plan.
This was done intentionally  

Monday, July 16, 2012

Tabular comparison of MYISAM INNODB

FACTOR INNODB  MYISAM
Locking Row Level Table Level
Transaction Allowed Not Allowed
crash recovery Reliable Less Reliable
Referential integrity (FOREIGN KEYs) Supported Not Supported
Insert / Updates Speed Faster because of row level locking slower because of table level locking
Concurrent Insertion If update/inserted rows are different , then the operation can be perormed simultanosly No
Concurrent Updation If update/inserted rows are different , then the operation can be perormed simultanosly No
Concurent insert and updates If update/inserted rows are different , then the operation can be perormed simultanosly If a MyISAM table has no holes in the data file (deleted rows in the middle), an INSERT statement can be executed to add rows to the end of the table at the same time that SELECT statements are reading rows from the table. If there are multiple INSERT statements, they are queued and performed in sequence, concurrently with the SELECT statements.
Large number of selects as compared to inserts/delete comparatively slow fast
storage limit 1/4x than myisam 4x than innodb
full-text search No No
system resources High Low
Count(*) speed is slow Fast
Backing Up Difficult Easy,  just need to copy FRM , MYD & MYI files.

Calling Functions Using Variable In Php

Problem Statement:
In Order to optimize my code , I was thinking how to write the last two lines of code in one statement.
$v1 = functionName;
$strR = "get".$v1;
echo $obj->$strR();     
as i wana get $obj->getfunctionName();


Solution :
echo $obj->{"get" . $v1}();


Reason :
1. Bench marking reports suggest the solution is optimized.
2. Code looks more professional.

php elephant