Re: Splitting tables across file systems

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. I haved moved various tables in a database to other FS by modifying the dirpath field in the systables record for the table I'm moving. I think there is an option for specifying the path when the table is created. Don't think you can -span- a single table across FS's. I'm dealing with complete tables. --Milt : ----------------------- : Jelks H. Cabaniss, III : cabaniss@cap.gwu.edu : ----------------------- -- ------------------------------------------------------------------------------ Milt Webb | email addresses> miltwebb@netcom.com Servantis Systems, Inc. | mfw@servantis.com 4411 East Jones Bridge Road | mfw@atl.fujikura.com Norcross, GA 30092 | Phone 404/840-1365(W) or 404/945-5896(H)