Any large churches doing check-in? Moving to SQL standard?

Josiah Rocke

unread,

Jun 14, 2016, 12:56:08 PM6/14/16

to Elexio Users

Is anyone on this group who is using Elexio Check-in for 500+ records on Sunday am? Anyone who has moved the sync server from the SQL express to full-blown SQL? We have having some issues with reports on Sunday AM, and I'm wondering if it might be related to the 1GB RAM limit of SQL Express. I have licenses available, but I'd like to talk about what setup other churches might be using.

Alex Lozada

unread,

Jun 15, 2016, 9:45:33 AM6/15/16

to Elexio Users

Yes, we moved from SQL Express to full SQL at the recommendation of Elexio staff, partly to increase responsiveness / decrease lag for weekend service Children's Ministry check-in. Have you worked w/ Elexio support on your issues on reports - running them SUnday AM during check-in prime hours, or after the fact during the week? At the time, we were 600+ records, now about 700-800+ records -- both figures over the nine weekend services NOT simultaneously one service....
== Alex

Josiah Rocke

unread,

Jun 16, 2016, 11:28:39 AM6/16/16

to Elexio Users

Alex, do you know what kind of hardware/software setup you have? I have a copy of SQL 2008R2, but the available 2008R2 server is kinda old....it will also install on Windows 7/8/10 (at least according to some people), and I have workstations with plenty of horsepower. I can also get the newer version of SQL/Windows Server. Just wondering what you guys are doing.

Reply all

Reply to author

Forward