ASP loading too slow

[Vitamin]

in what condition will lead the the ASP page run too slowing...

thx

[William Tasso]

Vitamin wrote:

> in what condition will lead the the ASP page run too slowing...
>

too much data
over-loaded server
poor query optimisation

dodgy connection
knackered workstation
poor browser

to name just a few.

you may want to narrow it down a bit.

--
William Tasso - [url]http://WilliamTasso.com[/url]

[Vitamin]

i think the query is a ig question in my point
sometimes, i need inner join more than 5 table...

"William Tasso" <ngx@tbdata.com> wrote in message
news:%23arUDNPfDHA.2484@TK2MSFTNGP09.phx.gbl...

> Vitamin wrote:

> > in what condition will lead the the ASP page run too slowing...
> >

>
> too much data
> over-loaded server
> poor query optimisation
>
> dodgy connection
> knackered workstation
> poor browser
>
> to name just a few.
>
> you may want to narrow it down a bit.
>
> --
> William Tasso - [url]http://WilliamTasso.com[/url]
>
>

[WIlliam Morris]

Try this:

Remove the query. If the page loads fast without it, then that's where the
problem is. The tables need indexes, or the query needs to be optimized.
You might also try moving to stored procedures.


--
William Morris
Product Development, Seritas LLC

"Vitamin" <hah@seeWhat.com> wrote in message
news:OcIDqiPfDHA.3284@tk2msftngp13.phx.gbl...

> i think the query is a ig question in my point
> sometimes, i need inner join more than 5 table...
>
> "William Tasso" <ngx@tbdata.com> wrote in message
> news:%23arUDNPfDHA.2484@TK2MSFTNGP09.phx.gbl...

> > Vitamin wrote:

> > > in what condition will lead the the ASP page run too slowing...
> > >

> >
> > too much data
> > over-loaded server
> > poor query optimisation
> >
> > dodgy connection
> > knackered workstation
> > poor browser
> >
> > to name just a few.
> >
> > you may want to narrow it down a bit.
> >
> > --
> > William Tasso - [url]http://WilliamTasso.com[/url]
> >
> >

>
>

[PB4FUN]

If you use that query a lot, I suggest creating a new table for that one.
If the seperate tables are changed, run a query to update the extra table.
If you try to fetch the records again it will go a lot faster.

Meindert, MCP

"Vitamin" <hah@seeWhat.com> wrote in message
news:OcIDqiPfDHA.3284@tk2msftngp13.phx.gbl...

> i think the query is a ig question in my point
> sometimes, i need inner join more than 5 table...
>
> "William Tasso" <ngx@tbdata.com> wrote in message
> news:%23arUDNPfDHA.2484@TK2MSFTNGP09.phx.gbl...

> > Vitamin wrote:

> > > in what condition will lead the the ASP page run too slowing...
> > >

> >
> > too much data
> > over-loaded server
> > poor query optimisation
> >
> > dodgy connection
> > knackered workstation
> > poor browser
> >
> > to name just a few.
> >
> > you may want to narrow it down a bit.
> >
> > --
> > William Tasso - [url]http://WilliamTasso.com[/url]
> >
> >

>
>