Re: MySQL General Discussion question

I'd use a cursor loop, and parse through the string extracting the numeric characters, convert the numeric characters to a Int to be used as a sequence number. Insert the sequence number and the string into a temp table, (or add seqnum to the current table) and select from X order by seqnum. I wo

Re: MySQL General Discussion question

Hi Rich, I believe that since they are definitely considered as strings they are sorted as such, how can you pretend that '#2 NOV' is considered as a number? If you cannot define a rule in the structure of the data it is impossible to sort, not only in sql, but in life! IF we take for granted

MySQL General Discussion question

Sorting a varchar field alphabetically with correct numerical order help needed I have a varchar 50 field that contains product names, which are typically numerical, alphabetical and punctuation thrown in. I would like to have them returned in some sort of order that is roughly alphabetical, b

Re: MySQL versus PostgreSQL for GPS Data

Juan: Still seems excessive but in that case, ignore inserts that have no change in lat / lon ... Jim > Jim Ginn wrote: > >>>Not sure why you you need the trucks location 'every second' ie: >>>31,536,000 rows per year per truck ? >>>doing every 30 seconds seems more manageable at 1,051,200 rows

RE: Performance Spamassin PostgreSQL vs MySQL

We had an awkward setup, which forced us to use PGSQL for SpamAssassin. Unfortunately the SA queries are not processed well by PGSQL. Back in January we switched SA processing to MySQL. Bingo! Instant improvement in overall performance, and no PGSQL maintenance required. This is not sophistica

Re: MySQL versus PostgreSQL for GPS Data

Jim Ginn wrote: >>Not sure why you you need the trucks location 'every second' ie: >>31,536,000 rows per year per truck ? >>doing every 30 seconds seems more manageable at 1,051,200 rows per year >>per truck? Maybe better at 60 seconds? OpenGGD is also designed to deliver GPS data in real time;

Re: copy blob between tables may get in consistent data?

hi, I found this: http://bugs.mysql.com/bug.php?id=34300 in the bug system. As it descibed, there is chance which I get corrupted data when read BLOB. Now I wonder why I also get corrupted data when write BLOB into table... I tried this: step 1: read BLOB data from TABLE1 step 2: l