basic architecture review?

2007-05-02 Thread Michael Higgins
Hello, list -- No problem, yet. ;-) Wondering if anyone would have a suggestion to ensure better performance, or could point out any likely errors in the database outlined below. Basically, I have digital pictures, scanned text/forms and emails that all relate to information indexed in a

Re: basic architecture review?

2007-05-02 Thread Dan Buettner
Michael, this looks pretty decent overall. I'm a big fan of fully descriptive table and column names, avoiding abbreviations except where truly needed, so I personally would spell out claim and claimant for example. I also like to separate words in table and column names with underscores, which

RE: basic architecture review?

2007-05-02 Thread Michael Higgins
-Original Message- From: Dan Buettner [mailto:[EMAIL PROTECTED] Michael, this looks pretty decent overall. I'm a big fan of fully descriptive table and column names, [8] (All good suggestions, thanks.) One performance suggestion: add an index on each table for the claim_id

RE: basic architecture review?

2007-05-02 Thread Jerry Schwartz
Buettner' Cc: mysql@lists.mysql.com Subject: RE: basic architecture review? -Original Message- From: Dan Buettner [mailto:[EMAIL PROTECTED] Michael, this looks pretty decent overall. I'm a big fan of fully descriptive table and column names, [8] (All good suggestions, thanks