There are no clear guidelines to follow when you have to decide which one is better the old Myisam or the transaction based innodb. In my experience the choice will differ from application to application and database operations that are frequently used.
Innodb comes with all the transactional database goodies and it is the choice if the database will be used as the OLTP with good number of reads and writes on it, It needs foreign key constraints . The table sizes aren’t big and the joins in the queries aren’t many.
But if the number of operations have to read most of the time and the application don’t require transaction control you must not overlook Myisam because it can give the kind of boost to your databse performance no other DBMS can compete with. Suppose if number of writes are more then every time a table is updated it will be locked for other operation this is not a problem with innodb which is row based.
nnoDB is a largely ACID (Atomicity, Consistency, Isolation, Durability) engine, built to guarantee consistency and durability. It does this through a transaction log (with the option of a two-phase commit if you have the binary log enabled), a double-write buffer and automatic checksumming and checksum validation of database pages.Myisam isn’t crash safe and if things go wrong getting db from the backup is the only choice.
Never think of mixed engine tables unless it is absolutely necessary. The mixed type table will give trouble at replication and at the time of backup.Performance analyzing and balancing will be difficult and slow. If a crash happens then to recover it wont be easy either.
Ovi store is the much hyped nokia version of apple store but it doesn’t come anywhere near to the latter either in the application it contains or the site usability. Ovi store have applications for the S60 based phones which again have many varieties among themselves like screen size and hardware resources. Ovi store have variant of applications for different type of phone models and the download link is sent to the mobile via sms. I tried it with my nokia 6110 navigator and many of the application links did not work.
The bigger names are missing even after one month when the ovi store is launched. The site usefulnuss is not good either, the pages sometime jam with the response to ajax did not come back, session times out pretty soon and the search don’t show relevant results. For the nokia phone owners at last there is a place where the users can look for the applications they wanted. But unlike of apple store the ovi store does not look like it will be the preffered way to distribute applications for the bigger application makers.
As many as 35 per cent of PCs built to run the Windows operating system have been downgraded to XP. performance testing software developer Devil Mountain Software said on a basis of a survey . while microsoft cut short the supply of windows XP to make Vista popular but that is doing nothing for unsatisfied users who are downgrading their pre installed Vista to XP.
microsoft is doing their best to revive interest to windows 7, the next version of windows. The company’s Windows’ boss Steven Sinofsky has even started up a new blog “honestly, I penned it where he proclaims that microsoft can deliver on time.
Whether the three bears – Apple, Linux and EU/US regulators – will wade in to spoil the party remains to be seen. But Microsoft really does need to dish up an operating system that is “just right” this time.