By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,704 Members | 1,122 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,704 IT Pros & Developers. It's quick & easy.

Mini search engine (call center)...

P: n/a
Hello,

I have developed a call tracking system for a small call center
utilizing an ASP server and an MSSQL server where the call center reps use
IE6 to enter in details of calls though the company's intranet system. I
have also made a search engine that basically uses a dynamic stored
procedure in the SQL server to cough up the results and search through the
old calls. The serch screen works fine on those smaller searches but it can
take its time (and sometimes sputter out) on the larger searches.

I do wish to improve the search screens performance. Currently, every
thing conforms to ASP 3.0. I display the result using a table in an iframe
which is not the most efficient but it was the easiest thing I could come up
with at the time. I am wondering if there is anything that ASP.NET could
offer to improve its performance? Would it be better to develop a VB.NET
plugin to perform this task? I have learned a fair bit about ASP but not
ASP.NET.

Any suggestions welcome...

TIA

A.
Nov 18 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Hi, regarding the search engine and using Stored Procedures. Have you
thought about using MSSQL's Free Text Search capability?

http://tinyurl.com/2w3e6

hth
Mark
"A. Nonymous" <so*****@hotmail.com> wrote in message
news:c7********************@giganews.com...
Hello,

I have developed a call tracking system for a small call center
utilizing an ASP server and an MSSQL server where the call center reps use
IE6 to enter in details of calls though the company's intranet system. I
have also made a search engine that basically uses a dynamic stored
procedure in the SQL server to cough up the results and search through the
old calls. The serch screen works fine on those smaller searches but it can take its time (and sometimes sputter out) on the larger searches.

I do wish to improve the search screens performance. Currently, every
thing conforms to ASP 3.0. I display the result using a table in an iframe which is not the most efficient but it was the easiest thing I could come up with at the time. I am wondering if there is anything that ASP.NET could
offer to improve its performance? Would it be better to develop a VB.NET
plugin to perform this task? I have learned a fair bit about ASP but not
ASP.NET.

Any suggestions welcome...

TIA

A.

Nov 18 '05 #2

P: n/a
I didn't get that far with T-SQL. I've been trying to learn ASP, T-SQL,
HTML and JavaScript simutaneously. I will look into it.

Thanks!

"John" <JD@noSpam.com> wrote in message news:c6**********@lust.ihug.co.nz...
Hi, regarding the search engine and using Stored Procedures. Have you
thought about using MSSQL's Free Text Search capability?

http://tinyurl.com/2w3e6

hth
Mark
"A. Nonymous" <so*****@hotmail.com> wrote in message
news:c7********************@giganews.com...
Hello,

I have developed a call tracking system for a small call center
utilizing an ASP server and an MSSQL server where the call center reps use IE6 to enter in details of calls though the company's intranet system. I have also made a search engine that basically uses a dynamic stored
procedure in the SQL server to cough up the results and search through the old calls. The serch screen works fine on those smaller searches but it can
take its time (and sometimes sputter out) on the larger searches.

I do wish to improve the search screens performance. Currently, every thing conforms to ASP 3.0. I display the result using a table in an

iframe
which is not the most efficient but it was the easiest thing I could come up
with at the time. I am wondering if there is anything that ASP.NET

could offer to improve its performance? Would it be better to develop a VB.NET plugin to perform this task? I have learned a fair bit about ASP but not ASP.NET.

Any suggestions welcome...

TIA

A.


Nov 18 '05 #3

P: n/a
Most probably your problem lies on database side and not in the ASP.
Execute only search procedures and watch performance.
Nov 18 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.