Quote:
select * from table where 1=1 take 45 minutes
table have 1 million records .
You are selecting 1 million records in a single select and you wonder why it takes time ?
You need a really faster server and a really fast network too.
Or learn database design.
PS: After 99 question, you still don't know what information are useful to us.