aalkan
Posts: 9
|
| Posted: 10/24/2008, 12:45 PM |
|
Hi;
Instead of listing the fields in the "sort by" list box for Search forms; you can list existing indexes; that will be very useful; because in large projects; indexes contains more than one field; also selecting an order by without an index would kill database for very large tables.
Thanks...
|
 |
 |
melvyn
Posts: 333
|
| Posted: 10/24/2008, 7:32 PM |
|
The coder must have common sense and set searchable fields as indexed.
CCS isn't aware from the database design. They're both independent.
In large projects, DB administrators and DB developers must work in team with coders.
_________________
Melvyn Perez
Puro Codigo
http://purocodigo.com |
|
|
|
|
