Re: mysql database

You are making the same mistakes that you made in a previous node (selecting from a mysqldatabase).

For starting, your SQL is not valid. Moreover, you are making a Cartesian product with your query. It means that if your tables ddts and deliver have 1000 records each, the query will return 1 million records.

There are other problems as well. It seems to me that you are doing a lot of cargo cult programming. Read again the answers to your previous post and then ask again what you need.

Comment on Re: mysql database

Replies are listed 'Best First'.
Re: Re: mysql database by eric256 (Parson) on Dec 12, 2003 at 16:22 UTC
I don't think your numbers are quite right on the query. He is checking `AND delivery.Data=ddts.Data` which will limit the data to just records that are 'linked' between the tables by there data field. Of course i don't know how valid that link is, but unless every record in both tables has the same data feild he should be okay. (Ignoring of course the comparison of `User`=\"@user\", i have no idea what thats suppose to do. ___________ Eric Hodges	[reply] [d/l] [select]

Replies are listed 'Best First'.

Re: Re: mysql database
by eric256 (Parson) on Dec 12, 2003 at 16:22 UTC

I don't think your numbers are quite right on the query. He is checking AND delivery.Data=ddts.Data which will limit the data to just records that are 'linked' between the tables by there data field. Of course i don't know how valid that link is, but unless every record in both tables has the same data feild he should be okay. (Ignoring of course the comparison of `User`=\"@user\", i have no idea what thats suppose to do.

___________
Eric Hodges

[reply]
[d/l]
[select]