New article: Getting More Conversions with the Same Traffic. Originally posted in the Clickbank newsletter. http://bit.ly/1peAws

Got back yesterday from a 3 week trip to Israel. Time to unpack, mow the lawn, etc… Pictures and stories to come during the next few days

Looking for large affiliates interested in private label sites for information products. www.infopay.com – hit me up at ASE if interested

Heading off to Affiliate Summit East tomorrow. Looking forward to meeting our affiliates there & connecting with new partners.

We have a large database that we need optimized to work much faster (about 80GB of data, 120,000,000 rows). The structure is below.

When we query a single row (LIMIT 1) or a small amount (i.e. LIMIT 0, 30) it runs very fast. But when ever we do something that needs to run through most of the table (like a specific select that does not exist) it takes a very long time. Also group by functions like count run slow.

All of our queries will be through PHP pages.

Ultimately we want to create browesable a directory.

Part of the work my entail actually importing the raw data into the MySql database. We have it broken down into about 1200 separate insert files. Right we have about ½ of the data imported so far.

The final result of this project will be us being able to run fast queries against the database to create a directory similar to the one on the lookupanyone.com website mentioned above. Name specific queries (ie when we are searching for only a single record) should render in the PHP in under a second. GROUP queries  should not take more then 10 seconds per page.

Our SafeID product just mentioned on the home page of Mass High Tech site – http://bit.ly/Nr2jj

Looking for a Boston area PHP/MySql Developer. If you know anyone that fits please have them contact me.

Why do so many potential clients want us to work with them without having a written agreement/contract? </rant>

Just finished posting 19 new items for sale in eBay. Crosses, Parchments, Noah’s Ark, Rosaries and more. Take a look at http://shop.ebay.com/merchant/alonyc_W0QQ_dmdZ1QQ_in_kwZ1QQ_ipgZ50QQ_sopZ12 and let me know what you think.

Obviously feel free to to forward to freinds or family that may be interested.