Sort an index Mysql
For sorting an index and data according to an index, use
(assuming that you want to sort on index 1).
This is the best way to make queries faster if you have a unique index from which you want to read all rows in order according to the index.
However, the first time you sort a large table this way, it may take a long time.
- Kiran's blog
- Add new comment
- 104 reads
Concurrent Inserts For MyISAM
MyISAM storage engine supports concurrent inserts. If there are multiple INSERT statements, they are queued and performed in sequence, concurrently with the SELECT statements.
The concurrent_insert system variable can be set to modify the concurrent-insert processing. This variable is set to 1 by default. To disable concurrent insert just set concurrent_insert variable to 0. If the variable is set to 2, concurrent inserts at the end of the table are allowed even for tables that have deleted rows. See also the description of the concurrent_insert system variable.
- Kiran's blog
- Add new comment
- 106 reads
cloud hosting
What is cloud hosting?
Cloud Hosting (often also referred to as clustered hosting) is a step up from the shared hosting infrastructure that is commonly used today. Generally, website hosted on a cloud hosting operates on a clustered servers where online operations are not limited to a single server. By handling security, load balancing and server resources virtually you are no longer restricted to the limits of one physical piece of hardware. In basic terms, online operations are not limited to a single server, they have access to the processing power of a number of servers that are distributed in real time.
Benefits of cloud hosting
Cloud hosting benefits the users from various angles. It’s scalability and cost efficient is the commonly known advantages.
- Kiran's blog
- Add new comment
- Read more
- 111 reads
Linux and Silverlight 2
Novell, in cooperation with Microsoft, has developed an open source version of Silverlight, called Moonlight, that is now available for Linux in version 2.
About Silverlight - it is a web browser plug-in developed by Microsoft that provides support for a wide range of multimedia functions, similar to Adobe Flash.
Version 3 of Silverlight has already been released several months ago. However, Moonlight 2 is based on Silverlight version 2, but includes some of the new features of version 3.
The open source licensing of
Moonlight
allows it to be included in Ubuntu and other
Linux distributions
- Kiran's blog
- Add new comment
- 117 reads
Google Chrome 3rd popular browser defeting Safari
From a recent survey by Net Applications Google's Chrome browser become the third most popular web browser by overtaking Apple's Safari browser.
Chrome and Firefox being open source, while Internet Explorer and Safari are proprietary.
Chrome's market share reaches 4.63 percent compared to Safari's 4.46 percent. Microsoft's Internet Explorer leads at top with 62.19 percent, followed by Firefox with 24.61 percent.
- Kiran's blog
- Add new comment
- 107 reads













