Importing Batch Data

• see also:
  • Delphi ASCII text import/export

Sybase ASE:

• Delphi BDE methods:
  • purging Sybase tables:
    • TTable.EmptyTable method:
      • simple, but slightly slow (eg. 1.5secs)
    • TQuery method (eg. "delete from dbo.tablename"):
      • fast (eg. 0.06secs)
  • importing records:
    • TBatchmove:
      • append:
        • fastest TBatchmove mode
        • risk of key violations
        • 26 rows/sec from an Access database
      • append & update:
        • very, very slow
      • update:
        • slow
      • copy:
        • creates data structures as well
        • approx. same speed as append mode
      • NB. requires a schema file if importing from a ASCII file
    • TTable.append method:
      • slow ~4.8 rows/sec from ASCII
    • TQuery:
      • SQL insert statement method
        •  
      • SQL bulk insert statement method
        •  
• Sybase BCP command:
  • fastest eg. 400 rows / sec?
  • requires ASCII text file and a schema file
  • should be similar to bulk insert  SQL command
• MS Access:
  •