Max no of rows in a lookup table

Users
1

Hi, I'm loading communes in Madagascar into a lookup table. How many rows
can commcare cope with? There are around 25,000 villages. Should I create
smaller look up tables?

thanks Nicola

2

Hi Nicola,

Performance with lookup tables can vary greatly depending on the power of
the Android device being used so its usually worth testing with one of your
own devices to get a sense of performance. However, 25,000 rows seems very
high so I'd definitely recommend breaking them up into smaller groups
assigned to users based on their location if possible. This will make user
restores and form entry using the tables faster.

Cheers,
Will

··· On Tue, May 9, 2017 at 12:58 PM, wrote:

Hi, I'm loading communes in Madagascar into a lookup table. How many rows
can commcare cope with? There are around 25,000 villages. Should I create
smaller look up tables?

thanks Nicola

--
You received this message because you are subscribed to the Google Groups
"commcare-users" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to commcare-users+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

3

Hi, I have 1,400 rows in my communes for Madagascar look up table. When one
of the users was entering some info today, the device 'hung' and then
skipped to the next question. Do you think this could be because its too
many rows? The user was using a Samsung Galaxy Tab A which is Android 5.1
Lolllipop.

thanks Nicola

··· On Tuesday, May 9, 2017 at 11:58:23 AM UTC+1, nic...@opfistula.org wrote: > > Hi, I'm loading communes in Madagascar into a lookup table. How many rows > can commcare cope with? There are around 25,000 villages. Should I create > smaller look up tables? > > thanks Nicola > >
4

Am just working on the same thing and would like to know how. As i have
about 344 villages. everything set well in lookup table. Districts and
wards filters perfect, villages dont filter at all. what could be the
problem, is it number of rows for the villages or?

thanx
Godliving

··· On Tuesday, May 9, 2017 at 2:21:52 PM UTC+3, William Pride wrote: > > Hi Nicola, > > Performance with lookup tables can vary greatly depending on the power of > the Android device being used so its usually worth testing with one of your > own devices to get a sense of performance. However, 25,000 rows seems very > high so I'd definitely recommend breaking them up into smaller groups > assigned to users based on their location if possible. This will make user > restores and form entry using the tables faster. > > Cheers, > Will > > On Tue, May 9, 2017 at 12:58 PM, <nic...@opfistula.org > wrote: > >> Hi, I'm loading communes in Madagascar into a lookup table. How many rows >> can commcare cope with? There are around 25,000 villages. Should I create >> smaller look up tables? >> >> thanks Nicola >> >> -- >> You received this message because you are subscribed to the Google Groups >> "commcare-users" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to commcare-user...@googlegroups.com . >> For more options, visit https://groups.google.com/d/optout. >> > >
5

Hello,

Its hard to say - could you send pictures of your lookup-table
configuration and the select question?

Cheers,
Will

··· On Fri, May 26, 2017 at 9:45 AM, Godliving Alfred Nnyari wrote:

Am just working on the same thing and would like to know how. As i have
about 344 villages. everything set well in lookup table. Districts and
wards filters perfect, villages dont filter at all. what could be the
problem, is it number of rows for the villages or?

thanx
Godliving

On Tuesday, May 9, 2017 at 2:21:52 PM UTC+3, William Pride wrote:

Hi Nicola,

Performance with lookup tables can vary greatly depending on the power of
the Android device being used so its usually worth testing with one of your
own devices to get a sense of performance. However, 25,000 rows seems very
high so I'd definitely recommend breaking them up into smaller groups
assigned to users based on their location if possible. This will make user
restores and form entry using the tables faster.

Cheers,
Will

On Tue, May 9, 2017 at 12:58 PM, nic...@opfistula.org wrote:

Hi, I'm loading communes in Madagascar into a lookup table. How many
rows can commcare cope with? There are around 25,000 villages. Should I
create smaller look up tables?

thanks Nicola

--
You received this message because you are subscribed to the Google
Groups "commcare-users" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to commcare-user...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups
"commcare-users" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to commcare-users+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

6

Hello William
below please see the lookup table configuration

https://lh3.googleusercontent.com/-fI-kSCCglcU/WSvVWBOfeEI/AAAAAAAACsE/teLA_nW2HpEZuah7TWtoRh0mi4mtnB5mgCLcB/s1600/District.JPG

https://lh3.googleusercontent.com/-xK7HuCfCR-k/WSvVcthxhPI/AAAAAAAACsI/mFMYwvtJ8F4Z_tQf2_6xmWoZdgczWiObQCLcB/s1600/Lookup%2Btable1.JPG

https://lh3.googleusercontent.com/-4hq_KZOckOQ/WSvVkeF0-TI/AAAAAAAACsM/eksnPbkpW1QIf38oT6TtBzwxVDH7ILBBwCLcB/s1600/villages.JPG

https://lh3.googleusercontent.com/-0ApoQCg1qjY/WSvVqbIYCYI/AAAAAAAACsQ/7pRzcNWg6gYpdrsCheADFd_JvQGph-tyQCLcB/s1600/Ward.JPG

··· On Friday, May 26, 2017 at 8:30:10 PM UTC+3, William Pride wrote: > > Hello, > > Its hard to say - could you send pictures of your lookup-table > configuration and the select question? > > Cheers, > Will > > On Fri, May 26, 2017 at 9:45 AM, Godliving Alfred Nnyari <god...@gmail.com > wrote: > >> Am just working on the same thing and would like to know how. As i have >> about 344 villages. everything set well in lookup table. Districts and >> wards filters perfect, villages dont filter at all. what could be the >> problem, is it number of rows for the villages or? >> >> thanx >> Godliving >> >> On Tuesday, May 9, 2017 at 2:21:52 PM UTC+3, William Pride wrote: >>> >>> Hi Nicola, >>> >>> Performance with lookup tables can vary greatly depending on the power >>> of the Android device being used so its usually worth testing with one of >>> your own devices to get a sense of performance. However, 25,000 rows seems >>> very high so I'd definitely recommend breaking them up into smaller groups >>> assigned to users based on their location if possible. This will make user >>> restores and form entry using the tables faster. >>> >>> Cheers, >>> Will >>> >>> On Tue, May 9, 2017 at 12:58 PM, wrote: >>> >>>> Hi, I'm loading communes in Madagascar into a lookup table. How many >>>> rows can commcare cope with? There are around 25,000 villages. Should I >>>> create smaller look up tables? >>>> >>>> thanks Nicola >>>> >>>> -- >>>> You received this message because you are subscribed to the Google >>>> Groups "commcare-users" group. >>>> To unsubscribe from this group and stop receiving emails from it, send >>>> an email to commcare-user...@googlegroups.com. >>>> For more options, visit https://groups.google.com/d/optout. >>>> >>> >>> -- >> You received this message because you are subscribed to the Google Groups >> "commcare-users" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to commcare-user...@googlegroups.com . >> For more options, visit https://groups.google.com/d/optout. >> > >
7

Hello,

Could you please also include a screenshot of the configuration of the
select question that is not properly filtering?

Cheers,
Will

··· On Mon, May 29, 2017 at 4:03 AM, Godliving Alfred Nnyari wrote:

Hello William
below please see the lookup table configuration

https://lh3.googleusercontent.com/-fI-kSCCglcU/WSvVWBOfeEI/AAAAAAAACsE/teLA_nW2HpEZuah7TWtoRh0mi4mtnB5mgCLcB/s1600/District.JPG

https://lh3.googleusercontent.com/-xK7HuCfCR-k/WSvVcthxhPI/AAAAAAAACsI/mFMYwvtJ8F4Z_tQf2_6xmWoZdgczWiObQCLcB/s1600/Lookup%2Btable1.JPG

https://lh3.googleusercontent.com/-4hq_KZOckOQ/WSvVkeF0-TI/AAAAAAAACsM/eksnPbkpW1QIf38oT6TtBzwxVDH7ILBBwCLcB/s1600/villages.JPG

https://lh3.googleusercontent.com/-0ApoQCg1qjY/WSvVqbIYCYI/AAAAAAAACsQ/7pRzcNWg6gYpdrsCheADFd_JvQGph-tyQCLcB/s1600/Ward.JPG

On Friday, May 26, 2017 at 8:30:10 PM UTC+3, William Pride wrote:

Hello,

Its hard to say - could you send pictures of your lookup-table
configuration and the select question?

Cheers,
Will

On Fri, May 26, 2017 at 9:45 AM, Godliving Alfred Nnyari < god...@gmail.com> wrote:

Am just working on the same thing and would like to know how. As i have
about 344 villages. everything set well in lookup table. Districts and
wards filters perfect, villages dont filter at all. what could be the
problem, is it number of rows for the villages or?

thanx
Godliving

On Tuesday, May 9, 2017 at 2:21:52 PM UTC+3, William Pride wrote:

Hi Nicola,

Performance with lookup tables can vary greatly depending on the power
of the Android device being used so its usually worth testing with one of
your own devices to get a sense of performance. However, 25,000 rows seems
very high so I'd definitely recommend breaking them up into smaller groups
assigned to users based on their location if possible. This will make user
restores and form entry using the tables faster.

Cheers,
Will

On Tue, May 9, 2017 at 12:58 PM, nic...@opfistula.org wrote:

Hi, I'm loading communes in Madagascar into a lookup table. How many
rows can commcare cope with? There are around 25,000 villages. Should I
create smaller look up tables?

thanks Nicola

--
You received this message because you are subscribed to the Google
Groups "commcare-users" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to commcare-user...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google
Groups "commcare-users" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to commcare-user...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups
"commcare-users" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to commcare-users+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

8

Hi Will,

I am trying to follow the example from CommCare help site to split my lookup table. But I can understand how the steps were laid out. Could you help in anyway?