>Hi everybody,
>
>Do you have any experience or some statistics in speed difference using WITH BUFFERING = .T. and with no buffering in Select-SQL?
>
>The process what normally takes ~1h now takes more than 3h and the CPU usage is at maximum level.
>
>Do you think we better use a different approach? The tables are table buffered and have ~300K records in each.
No, I've never done a proper testing for this. I usualy use
with (buffering=.t.) against my curently used and changed CAs or Buffered tables. But they are small. But 3h for 300K records? WOW!
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.