Seeking DBA Consultant for Large Database (MySql & PHP)

Posted by Alon Cohen on June 29th, 2009 under Uncategorized  •  No Comments

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.

Share and Enjoy: These icons link to social bookmarking sites where readers can share and discover new web pages.
  • Digg
  • Sphinn
  • del.icio.us
  • Facebook
  • Google
  • Blogosphere News
  • Blue Dot
  • Furl
  • Reddit
  • Slashdot

Our SafeID product just mentio…

Posted by on June 26th, 2009 under Uncategorized  •  No Comments

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

Share and Enjoy: These icons link to social bookmarking sites where readers can share and discover new web pages.
  • Digg
  • Sphinn
  • del.icio.us
  • Facebook
  • Google
  • Blogosphere News
  • Blue Dot
  • Furl
  • Reddit
  • Slashdot

Looking for a VAR Sales Manager (Boston)

Posted by Alon Cohen on May 18th, 2009 under Online Marketing, Sales & Marketing  •  No Comments

We just finished the technical side of a new e-commerce related service and are looking for a reseller sales manager to come in and take the lead on the sales side of the fence.

Contact info:
Email alon [at] accucomcorp [dot] com
Phone (617) 262-9317
Fax (617) 262-9325

No recruiters please.

Share and Enjoy: These icons link to social bookmarking sites where readers can share and discover new web pages.
  • Digg
  • Sphinn
  • del.icio.us
  • Facebook
  • Google
  • Blogosphere News
  • Blue Dot
  • Furl
  • Reddit
  • Slashdot

Looking for a Boston area PHP/…

Posted by on March 25th, 2009 under Uncategorized  •  No Comments

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

Share and Enjoy: These icons link to social bookmarking sites where readers can share and discover new web pages.
  • Digg
  • Sphinn
  • del.icio.us
  • Facebook
  • Google
  • Blogosphere News
  • Blue Dot
  • Furl
  • Reddit
  • Slashdot

Pictures of the December 2008 Ice Storm

Posted by Alon Cohen on December 20th, 2008 under Family  •  3 Comments

Last week we were one of the several hundred thousand homes left without power as a result of the ice storm. It brought out some of the best in people helping each other. It left us without power for almost two days (some people went without power for almost a week). We were one of the lucky families where the only damage we had was to about a 12 foot section of our fence.

You can also see pictures that my brother took at http://www.cohen123.com/IceStorm2008/ .

Share and Enjoy: These icons link to social bookmarking sites where readers can share and discover new web pages.
  • Digg
  • Sphinn
  • del.icio.us
  • Facebook
  • Google
  • Blogosphere News
  • Blue Dot
  • Furl
  • Reddit
  • Slashdot

Lesson from Sears: How to Lose a Customer in 10 Days

Posted by Alon Cohen on December 18th, 2008 under Sales & Marketing  •  No Comments

Within a short period of time Sears managed to lose a customer that has spent several thousand dollars with them over the years and would have continued to do so over time. All over about $200 and lack of accurate information their employees give customers over the phone.

The title may seem familiar to some of you, taken from the movie “How to lose a guy in 10 days” - http://www.howtoloseaguymovie.com/.

I’ve been a customer of Sears for quite a few years. On the bigger ticket items I will often get their extended warrantee – often the in-house option.

One example is the Craftsman Snow Blower (actually now they now called Snow Throwers) we bought about 4 years ago. In the first year it got a flat. No problem, called up Sears and their technician came out to our home and fixed it. Last year our extended warrantee expired and we chose to renew it. About a month after that the Snow Blower stopped working just as I finished clearing off my driveway. Again a call to Sears, they came out and fixed it at no charge, turned out to be a belt that needed to be replaced. Now that monster does not fit into my little Ford Focus so I would have had to rent a truck or U-Haul to bring it in to be serviced.

So far I was very happy with the service. About 2 weeks ago I thought I remembered that part of the extended warrantee included a yearly tune-up. I called Sears and they said that it was included and scheduled an appointment for the coming Friday December 12. The gentlemen on the phone gave me 2 options: 8-12 or 1-5. As I had some plans for the morning I chose the 1-5 option.

So, what’s the problem?

On Thursday (the day before the scheduled appointment) I received an automated call from Sears confirming my appointment between 8 AM and 5 PM. I called them back to specify that we scheduled 1-5, not a whole day appointment. I was informed that in my area they do not offer 4 hour windows, only whole day windows (Strike 1). As luck would have it, that Friday was the day of the big Ice Storm in New England. So the appointment got pushed off a few days until Tuesday.

Around 4:30 the technician called and came to our house. To our surprise he said that the tune-up was NOT covered in the plan we have and that we would need to pay $100 for it. He also said that we were not the first and not the last customers with the same issue. He told us that their extended warrantees had not cover tune-ups since 2000 (Strike 2). We chose not to pay the $100. As it turns out what they do in the tune-up is change the oil and check the spark-plug, both of which I was able to do my self. 

Ready for strike 3?

When we bought our home we also bought a Kenmore Dehumidifier from Sears. A bout a month ago it stopped working. I tried the usual – making sure it was plugged in, cleaning the filter and seeing if I could see anything wrong. The motor and fan were running, but it was not collecting any water. So about a week before the Snow Blower incident I called up Sears to see what warrantee options are available. From the manual I found that closed internal parts were covered by the manufacturer warrantee for 5 years.

Great, it was only 4 years. Now it looks like Kenmore is owned by Sears. When you go to their site for service they send you to Sears (http://www.kenmore.com/shc/s/nb_10154_12604_NB_CustomerCare?adCell=AH).  So I called up and the issues began.

The person on the phone told me that I had two options: to have someone come to my home or bring it to a repair center. After a few minutes of searching he said that their were no repair centers in my area and that my only option (other then driving to another state) was to have the repair done in my home. The cost to have a technician come over was about $100 or $65 if I brought it to a repair center.

I asked if that money would be refunded if it turns out the issue was under the manufacturer warrantee. To which he said no (Strike 3). Huh? Why am I paying $65 or $100 to repair something that is under warrantee? This was an item that we bought for about $160.

To anyone at Sears: Even in regular times you want to make sure that your customers are happy within reason. Even more so in these tough economic times. You need to make sure that:

1. The employees in your call centers are giving your customers accurate information (see strikes 1 & 2 above).

2. That your policies make sense and are reasonable (see strike 3 above).

Congratulations, within a short period of time you managed to lose a customer (me) that has spent several thousand dollars with you over the years and would have continued to do so over time. All over about $200 and lack of accurate information your employees give customers over the phone.

Update:
After publishing this post I also contacted Sears to get their response. Below is part of the email they sent me a few hours later.

…We apologize for the misinformation that you have received. Just to clear the record, what you paid for was a “trip” fee. You were actually covered under the warranty…

We truly apologize for this misfortune, and hope one day you may decide to come back to us. If you do not, we are sorry for our loss. We did appreciate you as our customer, and we try everyday, when training our employees to instill in them to ask, and not just answer a question, if they are not sure. It happens in every business. Unfortunately, we lost a great customer due to something like this: Misinformation, and Miscommunication on the product warranty.

We do appreciate you.

Sincerely,
Rosa…

It sounded like she just skimmed my post instead of fully reading it and did nothing to try and rectify the situation.

Share and Enjoy: These icons link to social bookmarking sites where readers can share and discover new web pages.
  • Digg
  • Sphinn
  • del.icio.us
  • Facebook
  • Google
  • Blogosphere News
  • Blue Dot
  • Furl
  • Reddit
  • Slashdot

New Website Design Launched

Posted by Alon Cohen on December 8th, 2008 under Online Marketing  •  No Comments

Over the weekend we re-launched the www.alorit.com site with a new, more modern and functional design.

 

Every now and then a website design needs to be updated. I’m not saying that you should redesign your site every month, but once every 1-2 years seems appropriate. When redesigning your site you need to take into account several factors:

 

  • Has your target audience changed in anyway since you launched the previous design? Was your site aimed at servicing to resellers/wholesalers in the past and now you also sell directly to retail clients?
  • Have browser capabilities changed? Are your visitors now using different browsers then before?
  • Have there been any changes in design “standards”? Hint: the rotating @ sign is kind of out-of-date.

 

That said, you can see my new and improved Online Marketing website at www.alorit.com. Feel free to give me a buzz and let me know what you think.

Share and Enjoy: These icons link to social bookmarking sites where readers can share and discover new web pages.
  • Digg
  • Sphinn
  • del.icio.us
  • Facebook
  • Google
  • Blogosphere News
  • Blue Dot
  • Furl
  • Reddit
  • Slashdot

Maya & Dvorit are Famous…

Posted by Alon Cohen on December 3rd, 2008 under Family  •  No Comments

…well, kind of. Here is a picture of them in the local newspaper. The Sentinel & Enterprise on Sunday November 30, 2008. This is the two of them making a rainbow fish at the 13th Family Literacy Fair by Project Apples, CPC.

 

Maya & Dvorit are Famous…

Maya & Dvorit are Famous…

Share and Enjoy: These icons link to social bookmarking sites where readers can share and discover new web pages.
  • Digg
  • Sphinn
  • del.icio.us
  • Facebook
  • Google
  • Blogosphere News
  • Blue Dot
  • Furl
  • Reddit
  • Slashdot

Why do so many potential clien…

Posted by on November 19th, 2008 under Uncategorized  •  No Comments

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

Share and Enjoy: These icons link to social bookmarking sites where readers can share and discover new web pages.
  • Digg
  • Sphinn
  • del.icio.us
  • Facebook
  • Google
  • Blogosphere News
  • Blue Dot
  • Furl
  • Reddit
  • Slashdot

New Items Up on eBay

Posted by Alon Cohen on November 18th, 2008 under Uncategorized  •  No Comments

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.

Share and Enjoy: These icons link to social bookmarking sites where readers can share and discover new web pages.
  • Digg
  • Sphinn
  • del.icio.us
  • Facebook
  • Google
  • Blogosphere News
  • Blue Dot
  • Furl
  • Reddit
  • Slashdot