If real time replication use a trigger. If periodic, make sure modulo of all files is the same so you get hashing efficiency
Sent from my Samsung device -------- Original message -------- From: Paweł Birgiel <[email protected]> Date: 19/05/2016 20:00 (GMT+10:00) To: jBASE <[email protected]> Subject: Fast copying of records from one table to another Hi. I have a task to make a service which will copy records from one table to another as fast as possible (using at most 5 agents). I have a problem with choosing the best way to do that. The most obvious solution seems to be using one READ and one WRITE (they appear to be a bit faster than F.READ and F.WIRTE) per each Y.ID in my main routine (after selecting list of records in SELECT routine). But it's still a bit slow way and I'm not sure I'm using service capabilities at one hundred percent. Another way is to use EXECUTE 'COPY FROM TABLE.A TO TABLE.B' for each record separately in main routine, but it doesn't seem to be faster. The most frustrating part is, when I'm using just jQL syntax in my shell and type something like: COPY FROM TABLE.A TO TABLE.B ALL, then sometimes it's even faster than my service! I was also thinking about another solution: SELECT TABLE.A WITH @ID LIKE LOC... COPY FROM TABLE.A TO TABLE.B This way we can copy multiple records at once. Maybe I should send larger chunks of id-s to the main routine of my service and then copy all of them? I made some tries and it doesn't seem to be much faster, sometimes it's even slower. Have you got any piece of advice for me? -- -- IMPORTANT: T24/Globus posts are no longer accepted on this forum. To post, send email to [email protected] To unsubscribe, send email to [email protected] For more options, visit this group at http://groups.google.com/group/jBASE?hl=en --- You received this message because you are subscribed to the Google Groups "jBASE" 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. -- -- IMPORTANT: T24/Globus posts are no longer accepted on this forum. To post, send email to [email protected] To unsubscribe, send email to [email protected] For more options, visit this group at http://groups.google.com/group/jBASE?hl=en --- You received this message because you are subscribed to the Google Groups "jBASE" 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.
