Forums Ultimate UI for Windows Forms
Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
Close
Rose
305
Saving Appointment as Byte Array - How Big?
posted

I can save appointments as byte arrays, but I need to determine the max number of bytes for the database.  The problem is that appointments can have reminders and the individual occurrences can me modified. So, is there a way to calculate the max size of the byte array needed to store an appointment with all its variancs using the Dave() method for an Appointment?

  • 2094
    Offline posted

    Does your DBMS offer a variable length binary type

     

    SQL2005 and onwards offers VARBINARY(max) data type

     

    It it difficult to speculate the size of your byte array's without first knowing what else you are storing in the appointment object. Simply write yourself that gets the maximum size of say 1000 sample/dummy appointments.

     

    Once you get the MAX size from your test, just double it for good measure :)

     

    Regards
    Aaron