
May 21st, 2011, 02:12 AM
|
|
Registered User
|
|
Join Date: May 2011
Posts: 1
Time spent in forums: 36 m 26 sec
Reputation Power: 0
|
|
|
Problem after Deleting huge no. of rows in table
Hello guys, i have problem with my database, it takes time to insert into my table containing 5,300,000 of rows, so idecided to delete by "DELETE FROM MYTABLE" ,then the problem arise,i can't open my table and i can't even backup by database because when gbak tries to write the data of mytable( table that i delete all the rows) it halts. Any help, or guide to tune-up my database, and how to do deleting all the rows of my table.
and how i can optimize my "insert" in huge table
thank you.
|