Tracking Forums, Newsgroups, Maling Lists  
Home Scripts Tutorials Tracker Forums
 
  HOME    TRACKER    MYSQL




Need Your Help!
please please help me -How can i sort MY sql data by most recent date.
Localization supporting for saving data into MYSQL
mysqlimport out of memory error
How to use AND in mysql
Warning mysql

UPDATE Function Very Slow??


I have a large table (77,321 Rows) and I'm trying to update it. For some reason, UPDATE takes a long time. Maybe it's my query? I'm doing it through php, maybe that's it? I'm running the program locally using the CLI, and it still takes ages.

Should I not expect it to be as fast as SELECT functions?

$update ="UPDATE `ch_products` SET `products_weight` = '".$IDS[$i][Weight]."' WHERE `xref1` = '".$IDS[$i][ID]."'";

How can I make this faster?




View Complete Forum Thread with Replies

See Related Forum Messages: (Click on the      Icon for short description)
Update Too Slow update too slow
Slow UPDATE slow UPDATE
Slow Update Query Slow update query
Very Slow Update Statement Very Slow Update statement
Very Slow Table Update Very slow table update
IF Function,GROUP BY,aggregate Function Problems IF function,GROUP BY,aggregate function problems
Slow Slow
Slow Query Slow Query
Slow Authentication Slow Authentication
Why Is This Query Too Slow? why is this query too slow?
Slow Query Log Slow Query Log
Slow Subselect Slow subselect
Slow Query Using NOT IN Slow Query using NOT IN
MySQL Slow MySQL Slow
Join Too Slow Join Too Slow
Slow Connection slow connection
Slow Connect Slow connect
Slow Queries slow queries
MySQL Very Slow. MySQL very slow.
Why Does MySQL So Slow Why does MySQL so slow
What Causes Slow Queries what causes slow queries
Very Slow Select very slow select
Slow Running Sql slow running sql
Complex Query - UPDATE Within UPDATE? Complex query - UPDATE within UPDATE?
Update Replication, Force Update Update replication, force update
Unable To Update - Have Update Priveledge Unable to update - have update priveledge
Order By Super Slow Order by super slow
Slow Left Join Slow left join
Slow Query Log Files Slow Query Log Files
Slow Query Log Not Staying On slow query log not staying on
Slow Response From MySQL Slow response from MySQL
Slow Response From MySQL Slow response from MySQL
Does Too Many Tables Slow Down Websites Does too many tables slow down websites
Slow Left Join slow left join
MS ACCESS Frontend SLOW MS ACCESS frontend SLOW
MySQL Slow In Windows NT4 MySQL slow in windows NT4
MySQL Is Slow, Trying To Optimize MySQL is slow, trying to optimize
Slow Write Speeds Slow write speeds
Extreamly Slow Search? Extreamly Slow Search?
Enabling -- Log - Slow - Queries Enabling -- log - slow - queries
MySQL Slow Starting Up MySQL Slow Starting Up
Slow Performance Using MyODBC Slow performance using MyODBC
MySQL Running Very Slow MySQL Running very slow
Slow Running MySQL? Slow running MySQL?
Query With 3.3million Rows Is Slow? Query with 3.3million rows is slow?
Can't Turn On Slow Query Logging Can't turn on slow query logging
Turning On Slow Query Logging? Turning on slow query logging?
Help Rewriting A Slow Phpbb Query Help rewriting a slow phpbb query
Remote MySQL Connection Slow Remote MySQL connection slow

Copyright © 2005-08 www.BigResource.com, All rights reserved