I think my case is the former. Like Sales support team prepare the
reply for the open request at the end of the day and upload. In the
evening, I have scheduled job on my AS400 do the upgrade from result
to request table with other information.
Insert each rows takes long time compared to update or delete. I think
it's slow because simply it will generate the number of statement with
the same number of rows. (500 rows = 500 insert statements) Can we
simply copy the selected rows to another ? I'm not sure.
On Feb 7, 3:19 pm, Richard Vézina <ml.richard.vez...@gmail.com> wrote:
> Do you have to let the user do that copy/paste because they add result to
> kind of empty CSV/Excel spreadsheet to feed your system or you only want to
> move data around once?
>
> In later case you can make a request at DB level or in web2py shell...
>
> Richard
>
>
>
>
>
>
>
> On Tue, Feb 7, 2012 at 3:48 PM, Omi Chiba <ochib...@gmail.com> wrote:
> > For example, I have two tables, "request" and "result". I want user to
> > download all open request (status="1") from "request" table and upload
> > with the result to "result" table.
>
> > What's the easy way to do ?
>
> > db.define_table('request',
> > Field('subject'),
> > Field('status', default="1"),
> > Field('result))
>
> > db.define_table('result',
> > Field('subject'),
> > Field('result))
>
> > Only thing I can think of is...
>
> > 1. delete result table
> > 2. Select request table with (status="1") and insert them to the
> > result table
>
> > But I'm on AS400 located in Japan and this additional insert process
> > takes too much time for me. The best way is download the selected data
> > with the header of result table...
