经典ASP中的超时问题 [英] Time out issue in classic ASP

问题描述

大家好，



我正在开发一个经典的ASP项目，当我从数据库中填充数据并在UI中绑定它时，我会遇到问题。



为了解决这个问题，我们试图进行分页但是没有成功。



可以任意一个人建议我，我们是否有其他方法来解决这个问题。



问候

Prashant P

Hi All,

I am working on a classic ASP project where I am getting time out issue when populating the data from DB and Bind it in the UI.

To resolve the issue we tried to do the pagination but it went un successfull.

Can any one suggest me, whether we have any other approaches to fix the issue.

Regards
Prashant P

推荐答案

没有代码，很难说发生了什么。对于数据库，它可能是很多东西。



首先我建议你需要优化你的分页情况 - 如果你分页你的行数减少所以性能应该提升 - 这里出了点问题，你需要检查所涉及的表的连接顺序。总的来说，这可能是一个相当复杂的过程其次，您的数据模式可能效率低下。您可能需要将索引添加到用于连接的列，假设它们不是主键或外键。最后，如果您没有将SQL作为存储过程运行，请将其迁移 - 尽管如果您的SQL运行缓慢，这不太可能有所帮助。

Without code it is hard to say what is happening. With databases, it could be a lot of things.

First I'd suggest you need to optimise how your pagination is happening - if you paginate your get fewer rows so the performance should shoot up - something is wrong here, you need to examine the join orders of the tables involved. Overall this can be a fairly complicated process. Secondly, your data schema might be inefficient. You might need to add indexes to columns that are used for joins, assuming they aren't primary or foreign keys already. Finally, if you are not running your SQL as a stored procedure, migrate it across - though this is unlikely to help if your SQL is running this slowly.

这篇关于经典ASP中的超时问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！