transport data across network

[2969]

Hi

I have a appliction which does the query on foxpro 7 database on the server and gets the results back in the form of recordset isng ADO.

now the data takes long time to get transported back to the client for ex. it takes around 20sec to execute the query but takes around 130 sec to tranport the data back to the client. Is there a way I can reduce this time.

 

[chiph]

1. Use a faster network (break it up into smaller segments, check for hardware errors, move high-usage machines to another segment, upgrade to 100baseT, etc)

2. Don't bring back as much data (don't use "SELECT *", only bring back columns you need, paginate result rows so that user sees initial answer sooner)

3. Make sure network card isn't set to "auto-select" the network speed. It should be set to the same speed as switch/hub and/or other PCs are set at.

Chip H.


If you want to get the best response to a question, please check out FAQ222-2244 first

 

[CCLINT]

Also, check out this info:

http://www.ftponline.com/Archives/premier/mgznarch/vbpj/1999/11nov99/pc1199/pc1199.asp

 

[2969]

the link is helpful, thx for the info.

I have another issue which this link doesnt addresses.

I am using crystal rpts and we have around 100+ reports. So quering the data takes long time. So i lloking to make a DCOM componnet which we query the data and send a recodset back to the client end. This recodset will now be used to print crysal rpt. The above link assumes to have certain numbers of fields in the query whereas my query is different for all 100+ rpts. So i cant use the above methodolgy as it requires me to declare and assign each field to a property. I can be using 10 fields in one query and in another i could be using 34 etc..

any ideas on this are appreciated.

thx

 

[CCLINT]

Send the sqlstring to the com server and build the query there using it...