Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2005
    Posts
    1

    Unanswered: Sybase Server Integration

    Hi All,
    I have the task to integrate 3 seperate Sybase Servers into one.
    The problem is how do i avoid the locks occuring during large inserts since now the application will be using only one server ?
    Can anyone help me with some approches for the same ?

  2. #2
    Join Date
    Dec 2004
    Posts
    46
    Table partitioning can be one. If your pgm used to access three different servers, i.e they should not be accessing same data anyway.

  3. #3
    Join Date
    Dec 2004
    Posts
    25
    Another simpler way is to create a clustered index on a non-unique column.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •