Sample Contacts CSV

[Lucspe]

Hi everyone,

I was wondering if there is a sample contacts csv file (that is a file
with some hunderds to a thousand sample contacts) to use for testing
available somewhere.

So far I've been testing the application with 1 shared address book
amongst two users, containing a few contacts, with sync every 5 mins
and the app has been consuming around 10-12% of daily CPU time.

Having a few hunderds sample contacts to import would really help me
test what happens regarding CPU time in a realistic scenario where
users are sharing such an amount of contacts.

Thanks in advance for your help and suggestions.

Luca

[Daniel Florey]

A few insights on CPU consumption:
In general the CPU consumption depends on
- total number of shared contacts
- total number of accounts subscribing to any shared address book
- sync frequency
- the number of modified contacts to be distributed

As all modified or added contacts need to be distributed to all
subscribers the load will be high when initially importing/adding
contacts to a shared group. Once they are shared, only modification
diffs will be distributed.
But anyway: Due to some App Engine datastore restrictions I have
iterate over all shared contacts in the database for each subscribing
account. So this will cause CPU load even if you are not making any
changes at all.
The free app engine quota will be fine for ~1000 contacts synced for
~10 subscribers all 5 minutes. If you have many more contacts or more
subscribers you should buy some extra quota (please select CPU
intensive preset) or reduce the sync frequency.
Reducing the sync frequency to every 15 minutes will reduce the CPU
load to 1/3 when not syncing new contacts.

[Speranza, Luca]

Thanks for the clarification.

 

 

2009/10/3 Daniel Florey <daniel...@gmail.com>

--
Luca Speranza
SO.FIN.TUR. Srl

[craig sweetnam]

i can give you my experience we have 6 users and 1900 contacts.

I have an iphone and and requested the change where by we could share the sytem contacts not just a contact group.

I also had some out look conversion issues this is a contact database that's origins are from a 1980's dos based program. (I found a contact for a company that went bankrupt in 1990)

I had many starts and stops this week and at one point had everyone with the system contacts shared and a group of 1900 contacts shared.

I have spent a whopping $2 this week.


one of my employees was not syncing nice. (the known issues fixed in 4.6).

So i just had that fixed yesterday. and yesterday cost me $0.06

i am syncing every 5 minutes.

I will let you know in the future how much it cost me but i expect it should be even less than $0.06 cents per day ongoing

2009-10-02 11:40:18	-	Usage Report for 2009-09-29	$0.06	$2.01
		Resource Used Free Billable Charge CPU Time: $0.10/CPU hour 7.03 6.50 0.53 $0.06 Bandwidth Out: $0.12/GByte 0.00 1.00 0.00 $0.00 Bandwidth In: $0.10/GByte 0.01 1.00 0.00 $0.00 Stored Data: $0.005/GByte-day 0.03 1.00 0.00 $0.00 Recipients Emailed: $0.0001/Email 11.00 2,000.00 0.00 $0.00 Total: $0.06
2009-10-01 14:37:58	-	Usage Report for 2009-09-28	$0.49	$1.95
		Resource Used Free Billable Charge CPU Time: $0.10/CPU hour 11.38 6.50 4.88 $0.49 Bandwidth Out: $0.12/GByte 0.00 1.00 0.00 $0.00 Bandwidth In: $0.10/GByte 0.01 1.00 0.00 $0.00 Stored Data: $0.005/GByte-day 0.03 1.00 0.00 $0.00 Recipients Emailed: $0.0001/Email 0.00 2,000.00 0.00 $0.00 Total: $0.49
2009-09-30 10:47:40	-	Usage Report for 2009-09-27	$0.48	$1.46
		Resource Used Free Billable Charge CPU Time: $0.10/CPU hour 11.29 6.50 4.79 $0.48 Bandwidth Out: $0.12/GByte 0.00 1.00 0.00 $0.00 Bandwidth In: $0.10/GByte 0.01 1.00 0.00 $0.00 Stored Data: $0.005/GByte-day 0.03 1.00 0.00 $0.00 Recipients Emailed: $0.0001/Email 0.00 2,000.00 0.00 $0.00 Total: $0.48
2009-09-29 12:56:23	-	Usage Report for 2009-09-26	$0.51	$0.98
		Resource Used Free Billable Charge CPU Time: $0.10/CPU hour 11.55 6.50 5.05 $0.51 Bandwidth Out: $0.12/GByte 0.00 1.00 0.00 $0.00 Bandwidth In: $0.10/GByte 0.01 1.00 0.00 $0.00 Stored Data: $0.005/GByte-day 0.03 1.00 0.00 $0.00 Recipients Emailed: $0.0001/Email 0.00 2,000.00 0.00 $0.00 Total: $0.51
2009-09-28 11:06:33	-	Usage Report for 2009-09-25	$0.47	$0.47

as for your request on a dummy csv file with a bunch of dummy data the only thought i had is there a government agency that might have a public telephone directory. you could import

--
Craig Sweetnam
Project Manager
PBC Sweetnam Holdings INC.
117 Covered Bridge Way
Carp On.
K0A 1L0
613 836 3005 x 333
Cell 613 978 8325
Home 613 288 8325

[Speranza, Luca]

Craig,

 

Thanks for sharing your experience. Very useful indeed.

 

If the AppEngine costs are within that range per day, it's more than acceptable.

 

Keep up the good work and let me know if you get different results while using it.

 

I've myself moved to a new phase of testing where (a subset of) users are actually involved, so I will let you know.

 

Luca

2009/10/3 craig sweetnam <swee...@gmail.com>