Re: ODBC Problem (urgent)
-- Are you accessing IIS over a network? If so this may be some of the
problem...
-- Are there other users hitting the IIS server at the same time, this could
also be a problem......
Regards,
James.
"Ken Mui" <kenmui@willas-array.com> wrote in message
news:39d3f19d$1@news.devx.com...
>
> I have a set of asp programs using ado to access foxpro 2.6 database for
DOS.
> The environment is PWS 4.0/Windows 98. I can see foxpro 2.6 data on the
browser
> and the speed to display is fast, about 3 seconds to completely display
all
> data. Notice that the database is in the PC runnning Windows 98.
>
> But when the set of asp programs are run under IIS 4.0/NT4, the speed to
> display data is very slow and not acceptable. Sometimes, the browser
cannot
> display all data and timeout.
> This time the database is in the PC running NT.
>
> I guess that it is the problem of ODBC because it is responsible for
connection
> between database and web server. I have checked several times that the
setting
> of ODBC is the same between Windows 98 and NT.
>
> Can anyone help me? Do I guess right? If not, what is the problem and
solution?
>
>
> Thanks a lot.
>
> Ken
Re: ODBC Problem (urgent)
Yes, IIS is accessed over a network and at the same time, there are more than
one users access IIS. Could you please tell me what is the problems and the
solutions?
Thanks a lot.
"James Dooley" <james@siteknowhow.com> wrote:
>-- Are you accessing IIS over a network? If so this may be some of the
>problem...
>
>-- Are there other users hitting the IIS server at the same time, this could
>also be a problem......
>
>Regards,
>
>James.
>
>"Ken Mui" <kenmui@willas-array.com> wrote in message
>news:39d3f19d$1@news.devx.com...
>>
>> I have a set of asp programs using ado to access foxpro 2.6 database for
>DOS.
>> The environment is PWS 4.0/Windows 98. I can see foxpro 2.6 data on the
>browser
>> and the speed to display is fast, about 3 seconds to completely display
>all
>> data. Notice that the database is in the PC runnning Windows 98.
>>
>> But when the set of asp programs are run under IIS 4.0/NT4, the speed
to
>> display data is very slow and not acceptable. Sometimes, the browser
>cannot
>> display all data and timeout.
>> This time the database is in the PC running NT.
>>
>> I guess that it is the problem of ODBC because it is responsible for
>connection
>> between database and web server. I have checked several times that the
>setting
>> of ODBC is the same between Windows 98 and NT.
>>
>> Can anyone help me? Do I guess right? If not, what is the problem and
>solution?
>>
>>
>> Thanks a lot.
>>
>> Ken
>
>
Re: ODBC Problem (urgent)
Hi There,
- Connecting to an IIS server over the network is always going to be
slower that a local connection, you're sharing the network with other
users and other applications. You could try and do some analysis
on the network and see if you can reduce over all traffic on the network
(assuming that it's a LAN). Of course you could always upgrade the
network if you've got the cash <g>.
- The IIS server will naturally slow down when it has to serve more
than one request. You could do some analysis on the server to see
what it's up to and try to improve performance - adding some memory
may help.
In reality though I'd say you need to think about redesigning your
application to handle the server and network bottlenecks. Think about
these ideas:
- Reduce that amount of records your shipping around, as a rule of thumb
if your sending more than say 20 records to the client you should think of
a new design.
- Provide search facilities so the user can locate and download only the
records they need.
- If the data does not change to much think about generating the pages
before hand with a background process.
- Off load some of the processing on to a second server by changing your
design to a Windows DNA one.
"kenmui" <kenmui_2000@willas-array.com> wrote in message
news:39d859ec$1@news.devx.com...
>
> Yes, IIS is accessed over a network and at the same time, there are more
than
> one users access IIS. Could you please tell me what is the problems and
the
> solutions?
>
> Thanks a lot.
>
> "James Dooley" <james@siteknowhow.com> wrote:
> >-- Are you accessing IIS over a network? If so this may be some of the
> >problem...
> >
> >-- Are there other users hitting the IIS server at the same time, this
could
> >also be a problem......
> >
> >Regards,
> >
> >James.
> >
> >"Ken Mui" <kenmui@willas-array.com> wrote in message
> >news:39d3f19d$1@news.devx.com...
> >>
> >> I have a set of asp programs using ado to access foxpro 2.6 database
for
> >DOS.
> >> The environment is PWS 4.0/Windows 98. I can see foxpro 2.6 data on the
> >browser
> >> and the speed to display is fast, about 3 seconds to completely display
> >all
> >> data. Notice that the database is in the PC runnning Windows 98.
> >>
> >> But when the set of asp programs are run under IIS 4.0/NT4, the speed
> to
> >> display data is very slow and not acceptable. Sometimes, the browser
> >cannot
> >> display all data and timeout.
> >> This time the database is in the PC running NT.
> >>
> >> I guess that it is the problem of ODBC because it is responsible for
> >connection
> >> between database and web server. I have checked several times that the
> >setting
> >> of ODBC is the same between Windows 98 and NT.
> >>
> >> Can anyone help me? Do I guess right? If not, what is the problem and
> >solution?
> >>
> >>
> >> Thanks a lot.
> >>
> >> Ken
> >
> >
>
Re: ODBC Problem (urgent)
Hi There,
Can you see my response from yesterday??? I can't seet it!
James.
"kenmui" <kenmui_2000@willas-array.com> wrote in message
news:39d859ec$1@news.devx.com...
>
> Yes, IIS is accessed over a network and at the same time, there are more
than
> one users access IIS. Could you please tell me what is the problems and
the
> solutions?
>
> Thanks a lot.
>
> "James Dooley" <james@siteknowhow.com> wrote:
> >-- Are you accessing IIS over a network? If so this may be some of the
> >problem...
> >
> >-- Are there other users hitting the IIS server at the same time, this
could
> >also be a problem......
> >
> >Regards,
> >
> >James.
> >
> >"Ken Mui" <kenmui@willas-array.com> wrote in message
> >news:39d3f19d$1@news.devx.com...
> >>
> >> I have a set of asp programs using ado to access foxpro 2.6 database
for
> >DOS.
> >> The environment is PWS 4.0/Windows 98. I can see foxpro 2.6 data on the
> >browser
> >> and the speed to display is fast, about 3 seconds to completely display
> >all
> >> data. Notice that the database is in the PC runnning Windows 98.
> >>
> >> But when the set of asp programs are run under IIS 4.0/NT4, the speed
> to
> >> display data is very slow and not acceptable. Sometimes, the browser
> >cannot
> >> display all data and timeout.
> >> This time the database is in the PC running NT.
> >>
> >> I guess that it is the problem of ODBC because it is responsible for
> >connection
> >> between database and web server. I have checked several times that the
> >setting
> >> of ODBC is the same between Windows 98 and NT.
> >>
> >> Can anyone help me? Do I guess right? If not, what is the problem and
> >solution?
> >>
> >>
> >> Thanks a lot.
> >>
> >> Ken
> >
> >
>
Re: ODBC Problem (urgent)
Hi,
I have read your useful message. Thanks a lot.
"James Dooley" <james@siteknowhow.com> wrote:
>Hi There,
>
>Can you see my response from yesterday??? I can't seet it!
>
>James.
>
>"kenmui" <kenmui_2000@willas-array.com> wrote in message
>news:39d859ec$1@news.devx.com...
>>
>> Yes, IIS is accessed over a network and at the same time, there are more
>than
>> one users access IIS. Could you please tell me what is the problems and
>the
>> solutions?
>>
>> Thanks a lot.
>>
>> "James Dooley" <james@siteknowhow.com> wrote:
>> >-- Are you accessing IIS over a network? If so this may be some of the
>> >problem...
>> >
>> >-- Are there other users hitting the IIS server at the same time, this
>could
>> >also be a problem......
>> >
>> >Regards,
>> >
>> >James.
>> >
>> >"Ken Mui" <kenmui@willas-array.com> wrote in message
>> >news:39d3f19d$1@news.devx.com...
>> >>
>> >> I have a set of asp programs using ado to access foxpro 2.6 database
>for
>> >DOS.
>> >> The environment is PWS 4.0/Windows 98. I can see foxpro 2.6 data on
the
>> >browser
>> >> and the speed to display is fast, about 3 seconds to completely display
>> >all
>> >> data. Notice that the database is in the PC runnning Windows 98.
>> >>
>> >> But when the set of asp programs are run under IIS 4.0/NT4, the speed
>> to
>> >> display data is very slow and not acceptable. Sometimes, the browser
>> >cannot
>> >> display all data and timeout.
>> >> This time the database is in the PC running NT.
>> >>
>> >> I guess that it is the problem of ODBC because it is responsible for
>> >connection
>> >> between database and web server. I have checked several times that
the
>> >setting
>> >> of ODBC is the same between Windows 98 and NT.
>> >>
>> >> Can anyone help me? Do I guess right? If not, what is the problem and
>> >solution?
>> >>
>> >>
>> >> Thanks a lot.
>> >>
>> >> Ken
>> >
>> >
>>
>
>
Re: ODBC Problem (urgent)
One speed up is on this web site, switch to a
connection string:
http://www.inquiry.com/techtips/asp_pro/top10/tip1.asp
