RE: Design Advice?

2004-02-27 Thread Zhao, Charles
/117c44d14811d2a97400a0c94492 61/content.htm -Original Message- From: Ed Lazor [mailto:[EMAIL PROTECTED] Sent: Friday, February 27, 2004 7:18 AM To: 'Zhao, Charles' Subject: RE: Design Advice? Hi Charles, Thought of a question... the stored procedure sounds like a way to combine and sort

RE: Design Advice?

2004-02-26 Thread Zhao, Charles
Your business requirement is not quite clear. Here are some questions that you need to answer before you finalize your design: 1. How often will the invoice be viewed (and I assume the viewers must be your web site users?) 2. What's the approximate traffic volume? 3. Will each time the users

RE: Design Advice?

2004-02-26 Thread Zhao, Charles
, or blob data in a separate table. Partitioning your invoice table based on time periods would also be an idea. -Original Message- From: Ed Lazor [mailto:[EMAIL PROTECTED] Sent: Thursday, February 26, 2004 12:16 PM To: 'Zhao, Charles'; [EMAIL PROTECTED] Subject: RE: Design Advice? Hi

MySQL 4.0 Installation Problem -- trying again

2004-01-08 Thread Zhao, Charles
- From: Zhao, Charles Sent: Wednesday, January 07, 2004 5:14 PM To: '[EMAIL PROTECTED]' Subject: RE: MySQL 4.0 Installation Problem Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno 13) ... Well, since

RE: MySQL 4.0 Installation Problem -- trying again

2004-01-08 Thread Zhao, Charles
- From: Zhao, Charles [mailto:[EMAIL PROTECTED] Sent: Thursday, January 08, 2004 12:22 PM To: [EMAIL PROTECTED] Subject: MySQL 4.0 Installation Problem -- trying again OK I was wrong: those files are mentioned in the doc, but I strictly followed the manual and I

RE: MySQL 4.0 Installation Problem

2004-01-07 Thread Zhao, Charles
starting the InnoDB tables. Both files mysql.sock and host.frm are not mentioned in the manual, and not found in my file system. Any one can point out the problem? Thanks. -Original Message- From: Zhao, Charles Sent: Tuesday, January 06, 2004 4:53 PM

MySQL 4.0 Installation Problem

2004-01-06 Thread Zhao, Charles
I have 3.23 that comes with my Linux distribution, now when I tried to do a rpm installation of 4.0, I got messages like: warning: MySQL-server-4.0.17 ... .rpm: V3 DSA signature: NOKEY, key ID ..., file /usr/bin/mysql from install of MySQL-client-4.0.17.0 conflicts with file from package

RE: Beginners Question

2002-04-05 Thread Zhao, Charles
retrieval speed and minimun memory size of my images. My images are just plain graphics, no rich colors. How can I realize the above purposes? Thanks for any help. -Original Message- From: Todd Williamsen [mailto:[EMAIL PROTECTED]] Sent: Monday, April 01, 2002 7:41 PM To: 'Zhao, Charles

Beginners Question

2002-04-01 Thread Zhao, Charles
Hello there, I am trying to find which database to use. I will have text and image data. Lots of image data. Most of the time I am doing data retrieving, but when updating, it will be text almost always. No enterprise use, but very busy database hits. Could any one please educate me if mysql