I have a need for columns of boolean data to indicate if items in my database have (or do not have) certain attributes. These are all truly yes/no values. For Derby what is the best approach for me to take (I have next to zero database experience so I am not aware of any best practices)? In my case if I had t pick performance over storage space in this application I would choose performance. I plan to query using these values (along with others); for example select all items that have attribute A but not attribute B.
Currently my application is using 10.1.3.1 but before my next release I will be upgrading to 10.2.1.6. Thanks, Ian -- Ian Leslie - Shareware Author (mailto:[EMAIL PROTECTED]) __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
