Re: Low performance due high network latency - batching ?

2009-10-20 Thread Dan Nelson
In the last episode (Oct 20), Bermejo, Rodrigo (GE Infra, Aviation) said: > We are facing a preformance issue with a desktop application which > connects remotly to a Mysql / DB ( ping times 300-800ms). We do not have > time to invest in modifications to create a 2-tier ... Web application > The

Re: Low performance due high network latency - batching ?

2009-10-20 Thread Johan De Meersman
Well, it's not exactly a clean approach, but if those are the limits you have to work within, so be it :-) I suspect you could gain some more performance by using MySQL's multiple select syntax. It's rougly like this: insert into *table* (*field*, *field*, *field*) values (*value*, *value*, * val

Re: Distinct max() and separate unique value

2009-10-20 Thread DaWiz
- Original Message - From: "Eric Anderson" To: Sent: Tuesday, October 20, 2009 4:05 PM Subject: Re: Distinct max() and separate unique value I'm trying to formulate a query on a Wordpress database that will give me the highest 'object_id' with the highest 'term_taxonomy_id', somethi

Low performance due high network latency - batching ?

2009-10-20 Thread Bermejo, Rodrigo (GE Infra, Aviation)
Hola List /. We are facing a preformance issue with a desktop application which connects remotly to a Mysql / DB ( ping times 300-800ms). We do not have time to invest in modifications to create a 2-tier ... Web application The initial plan was to implement a Client cache or a local DB (mysql sla

Re: Distinct max() and separate unique value

2009-10-20 Thread Eric Anderson
On Tue, 20 Oct 2009, DaWiz wrote: I would try: select max(object_id), term_taxonomy_id group by term_taxonomy_id order by term_taxonomy_id; max(column) returns a single value so distinct is not needed. The group by and order by should only have columns thaqt are displayed and that are not agg

Re: Distinct max() and separate unique value

2009-10-20 Thread DaWiz
I would try: select max(object_id), term_taxonomy_id group by term_taxonomy_id order by term_taxonomy_id; max(column) returns a single value so distinct is not needed. The group by and order by should only have columns thaqt are displayed and that are not aggregate columns. - Original Mes

Distinct max() and separate unique value

2009-10-20 Thread Eric Anderson
I'm trying to formulate a query on a Wordpress database that will give me the highest 'object_id' with the highest 'term_taxonomy_id', something like: +-+--+ | max(distinct object_id) | term_taxonomy_id | +-+--+ |

VFP to MySQL Query Optimization

2009-10-20 Thread Matt Neimeyer
I feel like there should be a better way to do this... So I'm hoping someone will be able to advise. We have contacts that belong to organizations. We also have a document tracker. Holding over from VFP you can have up to six organization ids on the document and up to six contact ids. Right now th

Re: Req. suitable .cnf file for Server used by 2000 users daily

2009-10-20 Thread Bruce Ferrell
this error indicates either root doesn't have sufficient privilege or the password entered was bad. try running it this way: ./mysqltuner.pl --user root --pass Jeetendra Ranjan wrote: > Hi, > > I run the mysqltuner at my server as below and i got error like below. > [r...@127 /]# ./mysqltuner.

Prepared statements and printing Queries

2009-10-20 Thread Chris W
I know this is more a PHP question but no one on the list at news.php.net is responding. So I was hoping someone here might know. If I am using the mysqli extension and prepared statements, after I execute bind_param, is there a away to print the actual query that gets sent to the server? I h

Re: Req. suitable .cnf file for Server used by 2000 users daily

2009-10-20 Thread Jeetendra Ranjan
Hi, I run the mysqltuner at my server as below and i got error like below. [r...@127 /]# ./mysqltuner.pl >> MySQLTuner 1.0.1 - Major Hayden >> Bug reports, feature requests, and downloads at http://mysqltuner.com/ >> Run with '--help' for additional options and output filtering Please ent