|
| Iniciado por nicholasgyh, 23,jun. 2016 04:11 - 1 respuesta |
| |
| | | |
|
| |
| Publicado el 23,junio 2016 - 04:11 |
dear group:
for each [file] where a=b and c=d
this sentence looks like simply,in a large database , i test "a=b and c=b" and "c=b and a=b"
one is display too slow ,another is very quickly, can you tell me how to set place of the conditions ,is more efficiency
thans |
| |
| |
| | | |
|
| | |
| |
| Publicado el 23,junio 2016 - 12:55 |
HI
I'm not sure I understand the question, but if I do, it's not the order
or presentation of the conditions that is going to change the speed,
it's what KEYS are available in the file for the system to find the data
The reason is that behind the scene, what you are really doing is a
hfilter or a query...
Best regards
--
Fabrice Harari
International WinDev, WebDev and WinDev mobile Consulting
More information on http://www.fabriceharari.com |
| |
| |
| | | |
|
| | | | |
| | |
|