CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com

Search:

Type: Posts; User: GremlinSA

Search: Search took 0.08 seconds.

  1. Re: [MySQL - PHP] Deleting many rows in a large table

    There is lots of talk on some sites that Updates and inserts are faster than deletes in many SQL database systems..

    try this code (as is for now, because it can be destructive to Data) and see how...
  2. Re: [MySQL - PHP] Deleting many rows in a large table

    well how long does it take??

    I know SQL server much better than MySQL, so the following might not exactly work, but look them up..

    TableLock vs Rowlock :locking the table(rather than row) will...
  3. Re: [MySQL - PHP] Deleting many rows in a large table

    Fastest way is to put the dates in the SQL query..

    Delete from [table] where [daterow] between [date1] and [date2]
    and call it once...

    something else to assist in the speed is to create an...
Results 1 to 3 of 4





Click Here to Expand Forum to Full Width

Featured