Re: Splitting tables across file systems

Milt Webb (miltwebb@netcom.com) wrote: : Jelks H. Cabanissg III (cabaniss@cap.gwu.edu) wrote: : : We have an Informix SE 5.01 engine on an Altos 15000 with : : SCO Unix. We are upgrade our machine to a second 486-50, : : more RAM, and multiprocessor extensions. We have been told : : that by splitting the tables across different file systems : : we can utilize the power of the multiprocessing capability. : : Question: Has anybody done this? Does it work? What are : : the repercussions? : : I know Online has multi-threading and SE doesn't. But could : : splitting the tables help avoid SQL CPU task saturation in : : an SE environment? Upgrading to Online is not an option at : : the moment. The only problem I have had with this is when I want to ( or need to ) run a bcheck on the table. It seems to want the table to be in the *.dbs directory. But maybe that was fixed on newer releases. Pete