Data Feed TXT Script Takes A Long Time To Be Created - Coding or Server?

[olimits7]

Hi,

 

I have a PHP script that runs and creates a *.txt data feed of all the products on my webste. I currently have around 130,000 products; which I don't think is that high of a number compared to the large ecommerce website.

 

My issue is it takes more than 5 minutes to create a simple *.txt data feed of only 20,000 records; not even the whole 130,000 records!!

 

1. So my question is can I increase the speed of this *.txt data feed process??

 

2. Could this be an issue with the code/queries not being optimized to the fullest??

 

3. Or is this a server issue??

 

Thank you,

 

olimits7