General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>Doru-
>That did it! I didnt even have to do two tableupdates()... I just turned the buffering off for the table. Thanks so much!
>Angie
Just a note: on my systems updatable views works fine for tables under 15MB in terms of time need to save records. On 800000records table(43MB) same view take ~10 to 25seconds to update (all the options are properly set - key field, update by key only).
I make this note to consider updating table directly using buffering instead of views
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only