Good Oracle Forum

This forum has been very helpful. There is always somebody that is willing to respond to queries. Does anybody know of a good Oracle forum? TIA Dan

mysqlconnecernet not closing connections w/2003

I posted this late last Friday. I'm hoping everyone missed it and that someone has an answer. :-) We have a quote server on both a 2003 server and an XP machine. The quote server is an asp.net server. The XP machine is closing the connections without a problem. For some reason

RE: mysqlconnecernet not closing connections w/2003

Robert- I apologize for not being clearer. The operating system is Windows 2003 Server. Dan -Original Message- From: Robert Dunlop [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 30, 2005 3:09 PM To: Daniel Cummings; mysql@lists.mysql.com Subject: Re: mysqlconnecernet not closing

mysqlconnecernet not closing connections w/2003

We have a quote server on both a 2003 server and an XP machine. The quote server is an asp.net server. The XP machine is closing the connections without a problem. For some reason the mysqlconnecernet is not closing the connections when used on the 2003 server. It connection count climbs to

Insert Delayed

Does Insert Delayed work on any version of MySql for INNODB tables? The docs state that it does but I keep getting the error that the engine doesn't support this. TIA Dan

speed issue - inserts slowing down selects

We have what is called a data grabber for quotes that is inserting rows into both InnoDb and MyIsam tables. When the data is being imported ( inserted ), it is dramatically slowing clients down that are running queries against the table. Our first attempt at a solution was to insert one row

RE: Insert Delayed

Thanks for verifying that. Dan -Original Message- From: John McCaskey [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 13, 2004 12:23 PM To: Daniel Cummings Cc: [EMAIL PROTECTED] Subject: Re: Insert Delayed I verified the same error for myself, and then found: http://bugs.mysql.com

Need to store a Guid as an Id

MySql doesn't support Guids but we were attempting to use a VarChar. We set the VarChar to binary, but from what I'm reading the binary setting doesn't affect storage just sorting and evaluations. I was able to get the binary storate I needed in a TinyBlob but I can't set this to a primary

Show Index Into Cursor?

Is there a way to force the results of Show Index From table Into a table? TIA Dan

RE: Show Index Into Cursor?

] Sent: Friday, July 16, 2004 11:35 AM To: 'Daniel Cummings '; '[EMAIL PROTECTED] ' Subject: RE: Show Index Into Cursor? You will have to put the value in a resultset and scroll through the resultset. Natively you can do this with MySQL 4.0.x but you could use a programming language. -Original

Get Updated Rows

Is there a way of getting the number of updated rows without using the API calls? TIA Dan

RE: Comparisons Through VFP not working properly

Roles This was just to determine how MySql was translating the parameter. It turned out to be a double in this new table. Dan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, July 15, 2004 7:00 AM To: Daniel Cummings Cc: [EMAIL PROTECTED] Subject: Re

Comparisons Through VFP not working properly

I'm using SqlPassthrough In VFP 8.0 Ive got a Sql statement that looks like this. This following fails: Update User Set Active = True Where UserId = ?pnUserId pnUserId is 222 in this instance. The following works fine: Update User Set Active =

RE: Understanding Explain in 4.1

Victor- It's a little misleading. It looks like it's going to do a full table scan of the Monday table. Dan -Original Message- From: Victor Pendleton [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 25, 2004 6:18 AM To: 'Daniel Cummings '; '[EMAIL PROTECTED] ' Subject: RE: Understanding

Understanding Explain in 4.1

These are two simple stock quotes tables that contain a symbol and a close amount. Explain Select Monday.Symbol, Friday.Close, Monday.Close From Monday Force Index(Symbol) Inner Join Friday Force Index(Symbol) ON Monday.Symbol = Friday.Symbol Symbol is a VarChar(20) in both

Heap table limitations

We want to convert a 200+ meg table to a heap table. We've gotten pretty good performance converting from InnoDb to MyIsam table but converting to a heap table would give an even bigger performance boost. Does making a heap file this large make any sense? Are there size limitations to

Multi-threading problems in MySql

We have one query which takes approximately 2 minutes. MySql seems to be unresponsive to any other threads until this query has completed. Are there some settings that aid with this kind of problem? TIA Dan