Category: Uncategorized

Indexes for database really make a different in query speed

Last time I have done the formatting workaround with the negative parenthesis.  This time I have to optimize the speed with the sync of the InDesign Plugin in Mac called datalinker from teacup software.  It is a database one-way sync program that does the price for you in InDesign Template Document.  The price is done Read More

Sybase T sql store procedure to substitute the negative number to negative parenthesis with case

I have tried to use a few examples online with stackoverflow.com and etc, but for sybase 12 I can’t find anything to make my store procedure to convert the negative number to negative parenthesis.  Worst thing is our database server didn’t enable java and I can’t really use replace_regexp to change the negative number to Read More

Stored Procedure for InDesign Database Plugin

Successfully got multi-column store procedure work out with group-by.  Use me around a week to figure it out and work on.  Well, Doing a InDesign with a database plug-in to call store procedure is much complicated than I thought before.  Working with price list like a catalogs and flyer is much simpler with InDesign, but Read More

Start up again with the post of my web techical blog

Welcome to my tech blog.  I am a web developer (can do some design).  You know, too many of them in the world but never be enough. Web world is change so big for this 15 years.  Still remember from the first day I step into a web market company to write pages and program Read More

1 2