Using an older version of R:Base: In multi –user mode with only one user connected I ran a test on a table with 400K rows
And it took 10 seconds. I then ran another text on a table with 300K rows: And it took 16 seconds. It really should be very fast. I remember running the command on specific tables for an active database and it went pretty fast. I imagine it would depend on how many columns you have in your table and how many are TEXT or NOTE. You can try running PACK INDEX first and see if it makes a difference Javier, Javier Valencia, PE 14315 S. Twilight Ln. Olathe, KS 66062 Office: 913-829-0888 Cell: 913-915-3137 -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Stephen Markson Sent: Friday, January 18, 2019 2:12 PM To: '[email protected]' Subject: RE: [RBASE-L] - Live RELOAD Hello Razzak, Thank you for that. Either something is wrong or this won't work for us. Our biggest table, `Exam`, has 200,000 rows. I tried PACK TABLE `Exam` on a copy of the database with only myself connected. It took over an hour, during which time the table was locked. Is this to be expected? I guess if the table is locked, then the time it takes does NOT depend on the number of database connections. Is that correct? Can a locked table prevent the PACK TABLE command from executing? It appears that the length of time it takes is mostly dependent on how "un-packed" the table is. Re-packing the table only took 3 minutes. Regards, Stephen Markson The Pharmacy Examining Board of Canada 416.979.2431 x251 -----Original Message----- From: [email protected] <[email protected]> On Behalf Of A. Razzak Memon Sent: January 17, 2019 5:04 PM To: [email protected] Subject: Re: [RBASE-L] - Live RELOAD Hello Stephen, A database PACK or RELOAD should be performed with MULTI set to OFF, to prevent users from altering the database during maintenance. However if there are several tables where file utilization can be improved greatly, in a multi-user environment, you may PACK those specific tables individually. PACK TABLE tblname Packing a single table is supported when MULTI is set ON, and is very beneficial with databases that are always is use. Note that performing a PACK on the database in multi-user mode will not decrease the database size, and will add the newly PACKed table to the existing database. The PACKed table, and indexes, will then benefit from the improved performance. To PACK/RELOAD a database with the intent of reducing the database size, the maintenance must be performed with MULTI set to OFF. In addition, for backups in an environment with constant database connections, use the SHARECPY command to make a copy for files that are shared on a network. Then, using that new copy, perform an AUTOCHK to ensure the SHARECPY was successful, and then perform the PACK/RELOAD. Very Best R:egards, Razzak At 10:44 AM 1/14/2019, Stephen Markson wrote: >Hello, > >I am looking for ideas on how to do database maintenance, like PACK or >RELOAD, while users are connected. > >We are running with STATICDB ON. Currently, we’re doing a RELOAD first >thing in the morning, before users are connected. This is working well, >but we’re looking for something better. > >Any ideas would be greatly appreciated. Thanks and… > > >Regards, > >Stephen Markson >The Pharmacy Examining Board of Canada >416.979.2431 x251 -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
