Improving loading speed

Last time, I posted about using Google's new tool that can help you analyze if your page needs further optimization. There are many reason to do it. First would be, the bandwidth space would be less than usual data transfer. This will be good since users won't have to wait a long time just to see your page and will also cost you less about site bandwidth (high-traffic websites).



First, it will ask you to complete the following suggestions.

and if you do what they suggested, you should get an optimized page, something like this...

which I think is cool. Way better if you serve many people and if you reference your SRCs wisely, chances are they don't have to download all those images, and just depend on HTML data. That's how it is designed and the web consortium designed it like that, to provide an easy, yet convenient way to communicate data over internet.

80% before deployment..

It's been weeks since I started the web project. So, now I'm in semi-testing, debug and fix mode. Every pictures now has the dynamic text I wanted plus rendering optimizations, which will improve once I uploaded it to the server, something faster than the development machine I'm using now. Also, I picked few SNS bookmarks, although there is hatena for japanese related contents. I'll consider adding it, after checking a week of web traffics.

I decided to just use on a flat database compared to the MS SQL 2008 DB (which is really small, so stiff that I have to develop an algorithm to just use 100MB of MS SQL DB as a buffer and rely on the physical storage as a database, thru an access file). It works as I expected until I decided to just keep the MS SQL 2008 DB for webservice that I might use in the future (probably for costing ads or review things...).

And URL encoding.. I know I should have, but for some reasons, I didn't (purposely)...

before asking me, please search in google for these words.

生産,seisan,produce, makejapanese sentence patterns |sayinjapanese


and, see the results while putting your attention on the "GREEN URL" part.


if you don't get it, just try making a sitemap with text like that and submit it to google, then try to fetch it as a googlebot. try it. it would be best if you do..


Just a few days more... I hope I can grab my credit/debit soon so I can up this as soon as possible. The worst case scenario is that, all banks will be close until January next year.....

Philippine banks' PayPal codes

Took a while to search for the list so I can integrate my paypal account to a local bank.

BANK NAME	9 digit bank code
ALLIED BANKING CORP	010320013
AUSTRALIA NEW ZEALAND	010700015
ASIA UNITED BANK	011020011
BANGKO SENTRAL NG PILIPINAS	010030015
BANGKOK BANK	010670019
BANK OF AMERICA	010120019
BANK OF CHINA	011140014
BANK OF TOKYO	010460012
BANCO DE ORO (& EPCIB)	010530667
BANK OF COMMERCE	010440016
BANK OF THE PHIL ISLANDS	010040018
CHINA BANKING CORP	010100013
CHINA TRUST COMML BANK	010690015
CITIBANK N.A.	010070017
DEVT BANK OF THE PHILS	010590018
DEUTSCHE BANK	010650013
EAST WEST BANK	010620014
EXPORT & INDUSTRY BANK	010860010
FUJI BANK	010640010
HONGKONG AND SHANGHAI BANK	010060014
INTL COMML BANK OF CHINA	010560019
INTL EXCHANGE BANK	010680012
JP MORGAN CHASE BANK	010720011
KOREA EXCHANGE BANK	010710018
INTL NEDERLAND BANK	010660016
LAND BANK OF THE PHILS	010350025
MAYBANK OF THE PHILS	010220016
METROPOLITAN BANK & TRUST CO	010269996
PHIL BANK OF COMMUNICATION	010110016
PHIL TRUST COMPANY	010090039
PHIL NATIONAL BANK	010080010
PRUDENTIAL BANK	010150018
PHIL VETERANS BANK	010330016
RIZAL COMML BANKING CORP	010280014
SECURITY BANK & TRUST CO	010140015
STANDARD CHARTERED BANK	010050011
UNITED COCONUT PLANTERS BANK	010299995
UNION BANK OF THE PHILS	010419995
UNITED OVERSEAS BANK	010270189

source(http://pages.ebay.ph/bankwithdrawal/bank_codes_ph.html)

Access as DB

in a website that I've been coding for weeks, I really need a DB to store site contents and pictures, unfortunately, the webhosting company charges more for less DB space (100 MB is my only option since I don't want to spend more). the disk space is 1GB.


then I looked at my VAIO P, it is 256GB and the RAM is 2GB, but still it is fit enough for development task. I had a thought of using the 100MB MSSQL 2008 DB space as a buffer and take advantage of the storage space using access DB.

with this, I can deploy the CMS of the website, be a web application or even a windows application. I can make the data model isolated and make a web service to invoke actions that will transfer data from the buffer to the access storage. of course, I need to make several files and I have to be sure to make backups as much as possible since access DB is much prone to be corrupted than SQL DBs.


just a little bit more.. I can't wait but it is also hard to type when your fingers get numb... (I'm starting to hate winter....)

Facebook hijacked?!

Whenever I type facebook URL in GoogleChrome or even click on google SERP, I always arrive here. Take note of the URL. It seems like a web design company in India... tried clearing the cookies, but it is still there.....

Targeting appropriate encoding

Writing web applications/website is easy and I can understand why other people can commit to do it in 10 straight days, but that is because they only focus on one language application/site. Eventually you will deal with a multilingual requirement that requires you to check against encoding.

Sometimes, just specifying the code below will not save you
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=(yourtarget encoding)">


so, here are the things you must consider, especially for dynamic pages.


1. Check or specify an encoding for your output.
on asp, you can specify codepage = number, example 932 for SHIFT-JIS

2. If not dynamic page, try to save the file in that encoding.

you can edit the page, re-save it, and use the "UTF-8" encoding.



3. specify the html attribute lang.
it will not help much in formatting, but at least help search engine bots to find and
determine the content of your site/application.

4. Check the font.

There are also times that, it is the font family that you're using that prevents the text to be rendered properly. For example,

日本 will be displayed as 日口 when using Copperlate Gothic Light.


5. Encode URL if you're using it as a link.

Since it will be used as a link, it will be passed in URL, and since the URL cannot accept non-ascii characters, there are possibilities of error. There won't be any problems in the SEO since, google can detect and convert them as the original text.
Url encoding will guarantee that a string will be passed correctly.

Another tool from Google. Page Speed Tool

By checking all the website I manager from fetching pages in googlebot's perspective, I noticed a new beta tool called Page Speed tool. I think google is always finding ways to improve web user's experience on the internet, and one of the factors that can ruin (piss, annoy, yell, tantrum, etc) a user is page loading time.

When I first learned my HTML (I was 15 years old, that time), displaying webpages thru frames is just a new thing and almost seen it everywhere. that time, if you understand HTML, you can be a web programmer (and a plus if you know javascript). All you have to do is, put your contents, put links, put images, put "Sorry, this site/section is under construction" sign, put noframes, noscript, etc... you just put everything, as in without consideration of user experience.

But now, if you still use that, it is like you didn't improve yourself for a long time. I don't want to sound mean, but when I see websites done using the Javascript preload method, I can assess their skill. Actually, I don't hate the javascript preload image way , in fact I used it many times, but that was when I was 15 years old, way back 11 years ago. I mean, if they want to pre-load images, just use CSS and preload the images there.


But still, that is like yesterday... I'm just fixing some last minute requirements (my cravings), for a website that I'll upload soon, and I really want to use this new Google Page Speed tool.

Page Speed tool seems to give your site a good diagnostic test and tips.
But in short, the only solution to this is to keep your files , as much as possible , limited.
On my site, I will just use 2 picture for the site layout and the other things will be from database. This technique is called "sprites", and no, before you open your mouth and let your soul go out, let me interrupt you that, this isn't a new technology. In fact, it was really really old, it was done as even earlier than you've seen Street Fighter or even Super Mario your NES (Family Computer).


Since you would minimize bandwidth usage by preventing browsers to download and download files, your site will load faster. If your website loads faster, your contents can be read faster, and (depending on your site) understand what you would like them to know. I know first impression is important, and last impression is lasting, but that is not the case when your page visitor doesn't even know you or in any way curious about you.


Great tool. Don't take my word for it. Use it and decide if your site is slow or not.

Difference between HttpInputFile and HttpPosted file.

while developing a new website and CMS where I need to manage uploaded files, I realized that the rchLibrary I wrote (idea from my previous work,and created a new version) only deals with the HttpInput file. To my knowledge I already coded an easy uploader for managing the uploaded files and checking the binaries, until I prefer to use the HttpPosted one.

Both are classes for uploads, with the first one, available on ASP.NET. But when you deal files , and you have to make ASP.NET controls for every file you need to upload... it will just make your application messy. (Well, ASP.NET is still a drag and drop, even those without solid experience in web development can still use it.).

But, using the HttpPosted file class will make your web app more flexible. All you have to do is to collect all the files posted and add them per posted file. You can also easily convert the stream to byte, and soon landing your database .