good night family
I have a csdb file of more than 3000 records that I query with Selcase, but the query on the cell phone is very slow, is there any way to make the query faster?
Atte. Paul Hinojosa
slow query ..Help
-
justinlakier
- Posts: 156
- Joined: November 21st, 2022, 4:41 pm
Re: slow query ..Help
Hello,
You can use StartsWith to optimize a search of your database by making sure it only searches through relevant cases. The "where" clause only filters the cases that SelCase has already found, your "StartsWith" needs to be after the dictionary name in the SelCase function, as the dictionary access parameters page on SelCase and StartsWith mentions.
Hope this helps,
Justin
You can use StartsWith to optimize a search of your database by making sure it only searches through relevant cases. The "where" clause only filters the cases that SelCase has already found, your "StartsWith" needs to be after the dictionary name in the SelCase function, as the dictionary access parameters page on SelCase and StartsWith mentions.
Hope this helps,
Justin