Re: [GENERAL] SQL question - problem with INTERSECT

2000-11-01 Thread Keith L. Musser
- problem with INTERSECT On Mon, Oct 30, 2000 at 07:59:06PM -0500, Keith L. Musser wrote: "(SELECT messages.msgid FROM messages, subject_index WHERE ((subject_index.word='Hello' or subject_index.word='There') and (subject_index.msgid = messages.msgid)) GROUP BY messages.msg

Re: [GENERAL] Re: JDBC Performance

2000-10-09 Thread Keith L. Musser
I did try out Peter's new JDBC driver on two very simple query-only applications. It was about 15% slower on one of the apps and 10% faster on the other, compared with jdbc7.0-1.2.jar. It worked correctly on both tests. Neither is particularly representative, but the fact that one's faster an

Re: [GENERAL] Re: JDBC Performance

2000-10-09 Thread Keith L. Musser
I did try out Gunnar's new JDBC driver on two very simple query-only applications. It was about 15% slower on one of the apps and 10% faster on the other, compared with jdbc7.0-1.2.jar. It worked correctly on both tests. Neither is particularly representative, but the fact that one's faster an

Re: [GENERAL] Re: JDBC Performance

2000-10-03 Thread Keith L. Musser
Where can I get the source for the JDBC driver? -Original Message- From: Peter Mount [EMAIL PROTECTED] To: Gunnar R|nning [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] [EMAIL PROTECTED]; PostgreSQL general mailing list [EMAIL PROTECTED]; Keith L. Musser [EMAIL PROTECTED] Date: Tuesday, October

Re: [GENERAL] Re: JDBC Performance

2000-09-29 Thread Keith L. Musser
) - Keith -Original Message- From: Gunnar R|nning [EMAIL PROTECTED] To: Peter Mount [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] [EMAIL PROTECTED]; PostgreSQL general mailing list [EMAIL PROTECTED]; Keith L. Musser [EMAIL PROTECTED] Date: Friday, September 29, 2000 9:08 AM Subject: Re: [GENERAL] Re

[GENERAL] Command names

2000-09-28 Thread Keith L. Musser
I know all of you are accustomed to the command line interface for pgsql. (Of course, some of you created it!) However, I'd be interested if anyone else feels the way I do I would prefer to have a consistent set of names for the commands. For example, I propose the following: Instead

[GENERAL] RE: JDBC Performance

2000-09-28 Thread Keith L. Musser
JDK1.3 on Windows NT. What is the best JVM to use on Linux? Does anybody have experience using the new HotSpot for Linux? Keith L. Musser Integrated Dynamics, Inc. 812-371- email: [EMAIL PROTECTED]