Monday, February 26, 2007

Asian Model Directory

Argh working on the Asian Model Directory is giving me a headache, basically different series made different directory hierarchy and I have to allow the script to adapt to different levels of folders.

I thought I got it right already I already uploaded 88Square 1-19, then on CD20 the script breaks cause of the Halloween set.

Thursday, February 22, 2007


Revised the slide viewer for the galleria, just minor changes with the cosmetics. There's still a bug with the picture moving forward when you change the zoom.

Wednesday, February 21, 2007


Cache_lite rocks! Without it my bandwidth was taking tremendous hit and now it takes a page in the cache 0.13 - 0.3 seconds to load. Had to reconfigure much of the existing pages as I was using it incorrectly

The whole site is looking much better now, more organized than before. Still got lots of plan for more features, one of them a model directory that identifies each model from different series. I know a lot of people miss the A4U Database. Hopefully I'll get it done tomorrow.

Monday, February 19, 2007

Finished the Slide viewer mode feature for the galleria last night. The option will show up on galleries that contains pictures and when using the TXT mode gviewer.

TN_gslide (38K)

Sunday, February 18, 2007


Finished the thumbnail version of the galleria and the random pics page. They both turned out quite nicely.

TN_gthumb (52K)
TN_random (37K)

Tuesday, February 13, 2007


I spent so much time last night trying to store thumbnails into mysql. I've always wanted to know if it was faster. So finally I did store it, but guess what, using the filesystem as thumbnail storage was faster. I was getting 2-3 secs total execution time when visiting a new gallery with no thumbnails yet when stored to mysql. While on the reiserfs it was like 1-2 secs, then after the thumbnails are generated it takes less than 0.20 secs to render a page but with mysql its like 0.35 or something then it just keeps getting higher the more thumbnail you have on the page.

Sunday, February 11, 2007

Well the server had a hiccup. . . actually I kicked the powerstrip and the whole thing just went down. This is a temporary server, I will move the site again to another server that has more disk space. Scary though on windows when the power shuts down mysql never had a problem recovering, on this server the tables got corrupted.


I found this old image on one of my CD's, this was back in college when I was running SG on an old pentium III. I had an 18 gb of HD space back then, now I have more than a terrabyte of HD space.

One major benefit of moving the site to ubuntu is now I can easily add directories thats outside of the main galleria simply by creating shortcuts, this would never have worked in windows. Or at least I couldn't find a way to make it work.

Fixed the quota reset, it not resets every midnight, forgot that I have to migrate the Asian4You database also which I created using Firebird . . . which was neat but slow as hell. Just have to recode the database I guess. The site is somewhat usable now, with the same functions as before, forum is up but we lost some data.

Arghhghhghgh I can't figure out how to reset the quota back Damn php5 not compiled with mysql support wtf!!!

Friday, February 9, 2007

So what's going on why is Site Geisha down you ask? Well currently migrating the entire site to my Ubuntu server.

The move went smoothly in fact I've also rewritten the galleria code and optimized the download code. I tested PHPBB3 Beta 5, but sadly the authentication script I use no longer works with it. So I guess we're stuck with PHPBB2 for awhile until PHPBB3 gets out of beta or until I can reconfigure the script.

Screenshot (7K)

Apache2 works so much better than IIS, with mod_deflate enabled I can conserve my bandwidth too. Also to save disk space full thumbnail previews are no longer available, only the first row of pics get a thumbnail.

Any suggestions/comments don't hesistate to email me, your admin ^_^ who's working solo to get SG back for all of you.