Mailing List
Home
Forum Home
MySQL General - General MySQL discussion
MySQL++ - Programming with the C++ API to MySQL
MaxDB - Everything about MaxDB, formerly known as SAP DB
ODBC - ODBC with the MySQL Connector/ODBC driver
MySQL on Win32 - Runing MySQL on Windows 9x/Me/NT/2000/XP
Java Help - Mostly related to the MySQL Connector/J driver
Perl - Perl support for MySQL with DBI and DBD::mysql
GUI - MySQL GUI Tools
Announcement
Subjects
• mysql openssl Question
• ERROR 1045: Access denied for user: 'root@localhost ' (Using
password: NO)
• Update one field with more fields from another table
• Getting Identity after INSERT
• ERROR 2002: Can 't connect to local MySQL server through socket
• mysql test 4 1 fails with the gis test
• MySQL Cluster Software
• Downgrade Mysql from 4 to 3 23
• Mysql 4 0 Oracle Stored Procedure Trigger Conversion
• Can 't access mysql after kernel upgrade
• Executing MySQL Commands From Within C Program
• Comparing and writing out BLOBS
• Preventing Duplicate Entries
• FULLTEXT query format question
• Strange behavior, Table Level Permission
• Does the binary log enabling affect the MySQL performances?
• mysql:it 's a db not a dbms how it 's possible?!
• mysql have same function mthod as Oracle decode()
 
Speeding Up Process

Speeding Up Process

2007-10-04       - By Rhys Campbell

 Back
"For Each" is always best avoided, think set based! Might be better if you
could forward your SQL.

Rhys

-- --Original Message-- --
From: Neil Tompkins [mailto:neildtompkins@(protected)]
Sent: 04 October 2007 12:19
To: My SQL
Subject: Speeding Up Process

Hi

I've the following process/queries which I want to speed up, for a product
inventory/warehouse which we have a number of items available to sell each
day

For Each Company
  For Each Product
     For Next 7 Days
       CheckQuantity        UpdateQuantity
     Next Day
  Next Product
Next Company

Is it possible to re-write this routine so that it executes quicker ?

Thanks,Neil
__ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ __
Get free emoticon packs and customisation from Windows Live.
http://www.pimpmylive.co.uk

This email is confidential and may also be privileged. If you are not the
intended recipient please notify us immediately by telephoning +44 (0)20 7452
5300 or email postmaster@(protected) You should not copy it or use it for
any purpose nor disclose its contents to any other person. Touch Local cannot
accept liability for statements made which are clearly the sender's own and are
not made on behalf of the firm.

Touch Local Limited
Registered Number: 2885607
VAT Number: GB896112114
Cardinal Tower, 12 Farringdon Road, London EC1M 3NN
+44 (0)20 7452 5300


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=mysql@(protected)