我正在做一个从PHP到PostgreSQL的查询,速度非常慢。查询是SELECT *, CAST(data->>'created_at' as timestamp) as fecha FROM gorda_lipo.tweets WHERE idusuario =125379829 LIMIT 20
在PHPpgadmin上它只需要21.172毫秒,但如果我尝试用pg_query(the connection, the query)在PHP上查询,查询会
警告: mysql_num_rows()期望参数1是第x行的资源。我检查了所有丢失的单引号和sql链接。 $query_1 = sprintf("select part_of_speech_id from word_parts_of_speech where word = '%s'", mysql_real_escape_string($v)); if(mysql_n