site Search:


 
    All Forums Hot Topics Gallery






how-to block ads


 
Search Topic:
Share Topic
Posting?
Post a:
Post a:
Links: ·ALL ·Review Your VoIP Provider ·VoIP Providers ·VoIP FAQ ·Porting Rules ·What Codec?
AuthorAll Replies

Mango
www.toao.net

join:2008-12-25
Alberta
kudos:11

reply to PX Eliezer

Re: By the numbers.

I just realized that if I switched from (npa) nxx-xxxx to npa-nxx-xxxx in our database I could save two bytes per customer!!!

RTuesday

join:2006-01-30

said by Mango:

I just realized that if I switched from (npa) nxx-xxxx to npa-nxx-xxxx in our database I could save two bytes per customer!!!

Better still, just pack it into three unsigned bytes (2^24) and format on output. Saves 11 out of your current 14 bytes... (and just turn away anybody who has those awkward foreign phone numbers).


Trev
IP Telephony Addict
Premium
join:2009-06-29
Victoria, BC
kudos:4

said by RTuesday:

Better still, just pack it into three unsigned bytes (2^24) and format on output. Saves 11 out of your current 14 bytes... (and just turn away anybody who has those awkward foreign phone numbers).

+1

And same for IP addresses. An IP address will fit in four bytes once converted properly (but make your column 16 bytes so you can store IPv6 addresses as well).
--
Wondering what I do? Find out at »www.digitalcon.ca
Get your Obihai ATA in Canada.

Mango
www.toao.net

join:2008-12-25
Alberta
kudos:11
Reviews:
·Anveo
·Shaw
·AcroVoice
·Callcentric
·callwithus
·voip.ms
·FreePhoneLine
·TELUS

I would, but they like to make notes with the phone number.

555-555-1234 (Bob's cell) / 455-555-1234 ext 7 / 355-555-1234 after 7pm

Actually, I was kidding when I mentioned saving disk space. The database that runs my employer's entire company is only 7MB!


Wednesday, 19-Jun 21:26:31 Terms of Use & Privacy | feedback | contact | Hosting by nac.net - DSL,Hosting & Co-lo
over 13.5 years online © 1999-2013 dslreports.com.
Most commented news this week
Hot Topics