Re: Table so slow to read

2006-05-05 Thread sheeri kritzer
1) See if the DNS on one machine is different. If it's trying to resolve the host on one and failing, that might be why it's slow. 2) how did you copy the database? 3) what's the data usage like on each machine? If one machine is used a lot and the other is used very little, then it may be

Re: Table so slow to read

2006-05-04 Thread Barry
Gabriel Mahiques schrieb: My name is Gabriel, "Saludos Cordiales" is the same than "Best Regard" in spanish. The server explanin is the same. The table structure is the same, the application is the same (redirect the data source only), the quantity of record is the same. All is the same, I copy

Re: Table so slow to read

2006-05-03 Thread Gabriel Mahiques
My name is Gabriel, "Saludos Cordiales" is the same than "Best Regard" in spanish. The server explanin is the same. The table structure is the same, the application is the same (redirect the data source only), the quantity of record is the same. All is the same, I copy the database from one serv