>Hi,
>Thank your for your reply
>
>1. Network : 10BaseT AND Ethernet
>2. my app User : 5
>3. my app is order entry system ( customer Data is about 13,000 rec and order data is about 15,000 rec )
>4. when I using index(CDX) in my DBC , my app is same speed -> Slow :-(
>5. my query -> "=SQLEXEC(nCon, "select cstno, cstnm, conm, copart, cotitle from customer where cstnm like 'choi%'", "tmp")
>
>Pls help me
>
>ASAP
1. SQL doesn't optimize when you use a wildcard character like the "%".
2. Do you have an index on the cstnm field?
3. Could you re-write the SQL code so the WHERE clause is ....WHERE cstnm = "choi" OR cstnm = "tmp"
This would allow an index on cstnm to optimize the code.
HTH
Barbara