RE: Erratic query performance

2009-08-14 Thread US Data Export
> >Any ideas of what could be causing the varied response time on a simple query >when everything on the server appears to be identical from one run to another? >Are there settings that can be made on the server to tweak response time for a >database/query like this? > [JS] Is it possible that ther

RE: Codd's rule 8 (physical data idependence)

2009-02-13 Thread US Data Export
>-Original Message- >From: Martijn Tonies [mailto:m.ton...@upscene.com] >Sent: Friday, February 13, 2009 4:40 PM >To: mysql@lists.mysql.com >Subject: Re: Codd's rule 8 (physical data idependence) > >Hi Jerry, > *Applications should not be logicaly impaired when the physical >storage >

RE: Displaying information from table graphically

2008-11-24 Thread US Data Export
>-Original Message- >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] >Sent: Sunday, November 23, 2008 6:12 AM >To: Jujitsu Lizard >Cc: mysql@lists.mysql.com >Subject: Re: Displaying information from table graphically > >Does it support interaction in terms of allowing user to click on >in

RE: Finding not quite duplicates

2008-11-18 Thread US Data Export
>-Original Message- >From: Bill newton [mailto:[EMAIL PROTECTED] >Sent: Tuesday, November 18, 2008 6:49 PM >To: Jerry Schwartz >Cc: 'mysql' >Subject: Re: Finding not quite duplicates > >I'm having a little trouble with your naming. I"m assuming the query you >listed should be: > >SELECT I

RE: normalised designs: customer database

2008-11-17 Thread US Data Export
>-Original Message- >From: Martijn Tonies [mailto:[EMAIL PROTECTED] >Sent: Monday, November 17, 2008 12:13 PM >To: 'mysql' >Subject: Re: normalised designs: customer database > > > >> If all you want to do is to restrict a field to certain values, and >aren't >> concerned with cascading o

RE: normalised designs: customer database

2008-11-14 Thread US Data Export
>-Original Message- >From: Martijn Tonies [mailto:[EMAIL PROTECTED] >Sent: Friday, November 14, 2008 10:44 AM >To: 'mysql' >Subject: Re: normalised designs: customer database > >> >3) create the customer table with a FK for people and a FK for >> >companies, and decide on the customer type

RE: Finding gaps

2008-10-27 Thread US Data Export
ng of self-joins. From: Peter Brawley [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 08, 2008 8:22 PM To: US Data Export; mysql@lists.mysql.com Subject: Re: Finding gaps Jerry, Here is a workaround for 4.1.22: SELECT a.id+1 AS 'Missing From', MIN(b.id) - 1 AS 'To' F

RE: Finding gaps

2008-10-08 Thread US Data Export
Well, 5.x accepted the query. It's been running for awhile, now, so I'll find out later if it did what I need. >-Original Message- >From: Peter Brawley [mailto:[EMAIL PROTECTED] >Sent: Wednesday, October 08, 2008 5:25 PM >To: Jerry Schwartz; mysql@lists.mysql.com >Subject: Re: Finding gaps

RE: Finding gaps

2008-10-08 Thread US Data Export
>-Original Message- >From: Gerald L. Clark [mailto:[EMAIL PROTECTED] >Sent: Wednesday, October 08, 2008 4:44 PM >To: Jerry Schwartz >Cc: mysql@lists.mysql.com >Subject: Re: Finding gaps > >Jerry Schwartz wrote: >> I'm finally getting back to this issue, and I've read the bits on >> artful

RE: simple design choice

2008-10-03 Thread US Data Export
>-Original Message- >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of >Alex K >Sent: Friday, October 03, 2008 2:15 PM >To: Mr. Shawn H. Corey >Cc: Rob Wultsch; mysql@lists.mysql.com >Subject: Re: simple design choice > >That seems like a nice trick. I suppose the flag would

RE: Deployment of Database in a DEB package.

2008-10-03 Thread US Data Export
>-Original Message- >From: Ellison, David [mailto:[EMAIL PROTECTED] >Sent: Friday, October 03, 2008 2:35 AM >To: mysql@lists.mysql.com >Subject: RE: Deployment of Database in a DEB package. > >That's true, you would need to consider that risk. Can a DEB package ask >for information before