PCR independent school management solution and website
Customer Portal
School Portal
Request Demo
SOLUTION
FAQ
PRICING
EMPLOYMENT
BLOG
SUPPORT
KNOWLEDGE BASE
Admissions
CMS Website
Community Connect
Finance & Student Billing
Fundraising / Development
Student Information
Cafeteria POS
Summer Camp & School
301-947-7380
sales@pcreducator.com
School Information Management System & Website Software
Blog
Why is my DAT Query or DAT Filter slow?
Why is my DAT Query or DAT Filter slow?
The
DAT Query
and
DAT Filter
are powerful and flexible features. Depending on the complexity of the query and the amount of data it may take some time to process the request. Even if the query looks simple, some of the tables are performing advanced calculations to make the data more convenient for you to work with. The more tables, conditions, and filters included in a
DAT Query
the slower it may become.
Some suggestions to improve the speed of your
DAT Query
or
DAT Filter
:
- Instead of using Contains, Not Contains, Starts With, or Ends With, use the “=” or “<>”
DAT Operator
s.
- Avoid relinking to the same table multiple times.
See also
DAT Operator
DAT Filter
DAT Query
DAT
PCR Educator K-12 School Information System is an online database engineered for independent and private schools to deliver the highest level of flexibility, unique experience, transparent communication and customized design. Being a complete cloud-based solution, PCR Educator system guarantees convenient access anytime, anywhere.
Facebook
Linkedin
301-947-7380
sales@pcreducator.com
Schedule Demo
Please, make sure that all required fields (marked with *) are completed.
School Name
*
Relation to School
*
select
Administration - Database Manager
Administration - Head of School
Administration - Registrar
Development - Director of Development
Finance - CFO
Finance - Business Manager
IT - Director of Technology
Other - Parent
Other - Staff
Other - Volunteer
Last Name
*
Your First Name
*
Your Email
*
Your Phone #
*
Household
User