Re: Dynamic ORing

Prepared Statements with the IN function worked beautifully. Performance is slightly degraded, but I get the functionality I want and can live with the slight performance hit. Thanks again. Dave > Hi Dave, > > Dave G wrote: >> Hello all, >> >> I'm trying to do

Re: Dynamic ORing

Thank you Baron, I'll give that a shot, and thanks for the IN() list tip ... much appreciated. Dave > Hi Dave, > > Dave G wrote: >> Hello all, >> >> I'm trying to do some processing on the front end to optimize my query >> on >> the backend.

Dynamic ORing

Hello all, I'm trying to do some processing on the front end to optimize my query on the backend. I would like to generate a list of id's for this query like so: SELECT REPLACE('3,4,5,6,7,8,9',',',' OR element_id=') INTO @tmp; Then use it like: mysql> select @tmp; +

Group wise maximum

ta | mediumblob | YES | | NULL| | ++--+--+-+-++ 6 rows in set (0.00 sec) mysql> This table can get quite large so I'm trying not to query on it twice to get the MAX(payload_time) < ptime. Obviously what I have is not the group-wise maximum I was hoping for. Dave G. -- MySQL Ge

Revised optimization question

I asked a question yesterday that was quite onerous, so I have been working out some of the details today, and would like to re-post my question under a different light. I have a table called data__ProcessedDataFrames that can grow to be gigantic, and I need to speed up the query for pulling the d

Re: optimization help

I do, but I don't see any way around that with the data I have. Dave G. > Good Afternoon David > > sounds as if you have a number of non-unique indices (even possibly FTS!) > slowing down queries..this should help you concentrate on the slower > indices > mysql> >

Re: optimization help

D payload_time > 11808.74704 AND payload_time < 1180564096.24967; What I'm concerned about is with how much data I will eventually have, even scanning over the KEYS will take a long time. Thanks Dave G. BTW: heres the giant query that I use. SELECT E.product_id,

optimization help

I have a table in my database (currently) that grows to be huge (and I need to keep the data). I'm in a redesign phase and I'm trying to do it right. So here are the relevant details: The table has several keys involved: mysql> desc data__ProcessedDataFrames; ++-

Re: jdbc with a UDF

t; > - michael > > > On 6/5/07, Dave G <[EMAIL PROTECTED]> wrote: >> I'm getting what appears to be a java reference back from values I >> return >> from a UDF. The values appear find using php, and in the mysql client. >> The result looks something lik

jdbc with a UDF

ll be appreciated. I searched on google and only found where another person had the same problem, but no solution. Dave G. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Mysql pushing data to client

Thanks for pointing that out, I'll go with James solution. David Godsey > David Godsey wrote: > > I am looking for a way to write a client program that will wake up when > > there is new data in the database, much like replication. > > > > So instead of my client pulling the database on some f

UTF-8 With MySQL 4.0.18 and PHP 2.5.5

My question is, do I have to step outside of phpMyAdmin to ensure that the correct encoding is being used? If I do so, will that affect future database management from within phpMyAdmin? Any advice would be much appreciated. -- Yoroshiku! Dave G [EMAIL PROTECTED] -- MySQL General Ma

RE: Integrating phpBB with an existing MySQL database

offering more specific help offlist. -- Yoroshiku! Dave G [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Integrating phpBB with an existing MySQL database

somewhere that phpBB uses a different hashing algorithm to encrypt it's passwords. Has anyone here been through a process like this before? Can anyone offer some tips and warnings about attempting this? -- Yoroshiku! Dave G [EMAIL PROTECTED] -- MySQL General Mailing List For list arc

Strange error on one table using phpMyAdmin

ry and follow any command line instructions anyone can offer that might help. Thank you for your help. -- Yoroshiku! Dave G [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: 4.1 Stable Enough For Beginner To Use? [SOLVED]

Thanks to all who responded. I think I will attempt to rn MySQL 4.1 for my web sites. -- Yoroshiku! Dave G [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

4.1 Stable Enough For Beginner To Use?

don't know enough to do anything more than very simple queries. So would you think that it's safe for me to use it, or would you recommend I hold off from it? -- Yoroshiku! Dave G [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.co

Storing utf-8 on MySQL 3.23.58, and preparing for MySQL 4.1

encoding? Will that be possible? Any advice would be greatly appreciated. Thank you. -- Yoroshiku! Dave G [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Storing mysql dates as an integer [SOLVED]

#x27;m only using it for events and people signing up for those events, so all the dates should be clustered around the present time. -- Yoroshiku! Dave G [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql

RE: Storing mysql dates as an integer

the format you describe. I want to know if there's any problem storing a UNIX timestamp purely as an integer in my MySQL database. -- Yoroshiku! Dave G [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Storing mysql dates as an integer

for this purpose? Any tips would be greatly appreciated. -- Yoroshiku! Dave G [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Newbie Question - can I collapse these two queries into one line? [SOLVED]

m expecting. > That's because you were being inefficient. :) Thanks for taking the time to respond! My script is working now! -- Yoroshiku! Dave G [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Newbie Question - can I collapse these two queries into one line?

t how to do that, I'm at a loss as to how to describe where my thinking is going wrong. Any help would be much appreciated. -- Yoroshiku! Dave G [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]