Do you use memo fields? How large are they? Have you packed memo at all lately? What about archiving records somehow? Does the system run slow no matter how many users on it? Any difference in speed from different POS workstations? Has the hardware been changed at all? Or a different hub or an old hub in place (time to get a switch?) Is it on an NT system or Novell? If Novell, have the deleted files been purged recently? Are the nics set to half-duplex, full-duplex, or auto? Just some things to consider... I'm in agreement with the others though on if you have multiple indices, can use RO, then a CDX will speed it up some.

Tracy

>dear all,
>
>i would like to know how can i creat cdx files from dbf outsite the tables creation time by code, the reasone for that i made long time a go inventory system with pos system using the idx file and now the system become slow so i need to increase the speed of the database by using cdx files while they are in multi user network system.
>
>thanking every body
>
>best regards
>hisham serry