ASP loading too slow

[Vitamin]

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

thx

 

[Vitamin]

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

 

[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

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

 

[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

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