Search

Wednesday, September 30, 2009

Auto increment in GridView

<asp:TemplateField HeaderText="Msg No">
<itemtemplate >
<%#Container.DataItemIndex + 1%>
</ItemTemplate>
</asp:TemplateField>

Saturday, January 10, 2009

Page Navigator Likes Google


//Page Navigator Likes Google
//By EThaiZone

//Current Page - เลขหน้าปัจจุบัน
$page = !empty($_GET['page']) ? $_GET['page'] : 1;

//Total Pages - จำนวนหน้าทั้งหมด
$all = 100;

//Amount of link's page - จำนวนลิงค์ที่แสดง (ถ้าเป็น 10 คือหน้า 10 หลัง 10 วิธีคิดเหมือนลิงค์ Google)
$amount_link_page = 10;


#########################

if($page > 1) {
if($page == 2)
$nav = " [Previous] ";
else
$nav = " [Previous] ";
}

$show = empty($amount_link_page) ? $all : $amount_link_page;
$start = ($page <= $show) ? 1 : $page-$show;
$end = (($all-$page)<$show ? $all+1 : $page+$show);

for($i=$start; $i<$end; $i++) {
if($i == 1 && $i!=$page)
$nav .= " 1 ";
else if($i!=$page)
$nav .= " $i ";
else
$nav .="[".$i."]";
}

if(($all-$page) > 0) {
$nav .= " [Next] ";
}

#########################

//Show link - แสดงลิงค์
echo $nav;

?>

Wednesday, January 7, 2009

Compile C++ code in ubuntu

One of many question of user who switch from window to linux to have how to compile c/c++ source code. Most of study c or c++ at school or home an are usually use windows.

I think simple to start compile c/c++ in ubuntu to use first an editor like nano and create a source file then compile using gcc in command line. but first to install gcc complier and survival other utilities for compile software. use .

sodu apt-get install build-essential

build-essential is a meta package - a package which only depends on other packages, so installing it will automatically install several tools like gcc, g++ or make.

Next, create your source file using a text editor of choice (I used Nano for this example):

nano main.c

Enter the content, e.g.:

#include

int main ()
{
printf ("Hello, world!\n");
return 0;
}


Notice that I also included a newline after the close bracket, otherwise the compiler will issue a warning. Save it with CTRL+O, then exit Nano using CTRL+X. To compile your source, simply use:

gcc main.c -o myapp

The output, myapp, will automatically be executable, so to run it use:

ubuntu@ubuntu:~$ ./myapp
Hello, world!

This is the simplest way of creating and compiling C or C++ code.

Monday, January 5, 2009

Speed Up Mysql query cache size

One of the best ways to speed up your web application is to enable query caching in your database, which caches commonly used SQL queries in memory for virtually instant access by the next page that makes the same request.

The reason this method is so powerful is that you don't have to make any changes to your web application, you just have to sacrifice a little bit of memory. This isn't going to fix all of your problems, but it definitely can't hurt.

Note: if your application updates tables frequently, then the query cache will be constantly purged and you won't get much or any benefit from this. This is ideal for an application that mostly does reads against the database, such as a Wordpress blog. This also won't work if you are running on shared hosting.

Enable Caching with Server Running

The first thing you'll want to do is make sure that your installation of MySQL actually has query caching support available. Most distributions do, but you should check anyway.

You'll want to run this command from your MySQL console, which will tell you if query caching is available.

mysql> show variables like 'have_query_cache';
+------------------+-------+
| Variable_name | Value |
+------------------+-------+
| have_query_cache | YES |
+------------------+-------+

Don't mistake this as meaning that query caching is actually enabled, because most hosting providers aren't going to enable this by default. Oddly enough, my Ubuntu Feisty installation already had it enabled…

Next we'll need to check and see if query caching is enabled. We'll need to check more than one variable, so we may as well do it all at once by checking for the variable query%

mysql> show variables like 'query%';
+------------------------------+---------+
| Variable_name | Value |
+------------------------------+---------+
| query_alloc_block_size | 8192 |
| query_cache_limit | 1048576 |
| query_cache_min_res_unit | 4096 |
| query_cache_size | 8388608 |
| query_cache_type | ON |
| query_cache_wlock_invalidate | OFF |
| query_prealloc_size | 8192 |
+------------------------------+---------+

Here's the important items in the list and what they mean:

* query_cache_size - This is the size of the cache in bytes. Setting this value to 0 will effectively disable caching.
* query_cache_type - This value must be ON or 1 for query caching to be enabled by default.
* query_cache_limit - This is the maximum size query (in bytes) that will be cached.

If the query_cache_size value is set to 0 or you just want to change it, you'll need to run the following command, keeping in mind that the value is in bytes. For instance, if you wanted to allocate 8MB to the cache we'd use 1024 * 1024 * 8 = 8388608 as the value.

SET GLOBAL query_cache_size = 8388608;

Similarly, the other options can be set with the same syntax:

SET GLOBAL query_cache_limit = 1048576;

SET GLOBAL query_cache_type = 1;

Now how do we tell if it's actually working? You can use the SHOW STATUS command to pull all the variables that start with "Qc" to take a look at what is going on under the hood.

mysql> SHOW STATUS LIKE 'Qc%';
+-------------------------+--------+
| Variable_name | Value |
+-------------------------+--------+
| Qcache_free_blocks | 65 |
| Qcache_free_memory | 201440 |
| Qcache_hits | 18868 |
| Qcache_inserts | 2940 |
| Qcache_lowmem_prunes | 665 |
| Qcache_not_cached | 246 |
| Qcache_queries_in_cache | 492 |
| Qcache_total_blocks | 1430 |
+-------------------------+--------+
8 rows in set (0.00 sec)

You'll notice in the stats that I have plenty of free memory left. If your server shows a lot of lowmem prunes, you might need to consider increasing this value, but I wouldn't spend too much memory on query caching for a web server… you need to leave memory available for apache, php, ruby, or whatever you are using.

Enable in Config File

If you want these changes to survive a reboot or restart of the mysql server, you'll need to add them into your /etc/mysql/my.cnf configuration file for MySQL. Note that it might be in a different location on your installation.

Open up the file using a text editor in sudo or root mode, and then add these values if they don't already exist in the file. If they do exist, just uncomment them.

query_cache_size = 268435456
query_cache_type=1
query_cache_limit=1048576

Query caching can significantly improve the speed of your web application, especially if your application does mostly reads. Monitor the status using the methods above and see how it works over time.

link : http://www.howtogeek.com/howto/programming/speed-up-your-web-site-with-mysql-query-caching/