Woooah stop. So you are connecting via your dev machine over a 100mbit or more connection to your prod server and are measuring download of row counts....
Suggest you set up some sort of bandwidth throttling on your machine, then try out your tests again. The issue isn't how many, but what the connections speed of the client is. Honestly speaking, you need to look at use ability here. Nobody can see 10,000 records, so get the 1st 100, display them (100 of 10456 records shown), and get the user working, not waiting. In the background get the rest *if you have to*. You're going to get a sales person to demonstrate this at some point on a clients site and he's going to hook up to the internet via a mobile phone and you will lose the sale. Also of note is that those 10k records you are retrieving is one server thread serving up your request for over a second. In a multi-user app, that type of unnecessary data bloat can easily cause massive performance issues. Chad Gray wrote: > > That is on my dev box. It runs the SQL server and the CF server. > > The production box the SQL server is on a separate box. I just ran the > same test on the production box and it is less then a second. Of > course it is a much faster CPU. > > I bumped it up to 10,000 records and the production server is at 1 > second now. The dev server is at 6seconds. > > -----Original Message----- > From: [email protected] <mailto:flexcoders%40yahoogroups.com> > [mailto:[email protected] > <mailto:flexcoders%40yahoogroups.com>] On Behalf Of Adam Reynolds > Sent: Tuesday, March 11, 2008 9:41 AM > To: [email protected] <mailto:flexcoders%40yahoogroups.com> > Subject: Re: [flexcoders] max rows to return to a datagrid > > Was that you working on your dev box or did you connect to a remote > server? > > Chad Gray wrote: > > > > I am using a Coldfusion CFC to return a query object that is bound to > > a datagrid. > > > > Is there any rule of thumb as to how much data you should send to the > > datagrid? > > > > I just tried 3000 rows of data and it took about a second for the > > datagrid to display it. > > > > > > -- > Flexcoders Mailing List > FAQ: http://groups.yahoo.com/group/flexcoders/files/flexcodersFAQ.txt > <http://groups.yahoo.com/group/flexcoders/files/flexcodersFAQ.txt> > Search Archives: > http://www.mail-archive.com/flexcoders%40yahoogroups.com > <http://www.mail-archive.com/flexcoders%40yahoogroups.com> > Yahoo! Groups Links > >
