Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jesus4u
Posting Yak Master
204 Posts |
 Posted - 2001-12-04 : 09:40:01
|
| I have some issues, please help with answers. I need to parse 32,000+ records from a SQL2000 DB and then display the results onto an HTML page. What would be in your opinion the FASTEST way to parse my data and then display it to the user in HTML? Do the parsing in a DLL, on the ASP page, in a Stored Proc? Oh also, the time to parse and display data needs to be under 30 seconds! Nice huh? Thanks... |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2001-12-04 : 09:46:33
|
| See if this helps you:http://www.sqlteam.com/Forums/topic.asp?TOPIC_ID=11019Don't be surprised if it won't run that fast though; data access for 32,000 rows could easily be accomplished in 30 seconds, but HTML rendering time will not. Not to mention the type of connection the end-user has, a dial-up will never get near 30 seconds.And I have to ask, who really needs to display 32,000 rows on a single HTML page? I'd hate for you to spend a ton of time trying to do it when basically there's no way, and IMHO this is a ridiculous request. |
 |
|
|
jesus4u
Posting Yak Master
204 Posts |
Posted - 2001-12-04 : 09:58:42
|
| NO I don't need all records back. I need to display to the end user the total number of keywords found for all the records. For example: Show the user this dsl providers 156 dsl 456 california dsl companies 567 and so on... |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2001-12-04 : 10:03:23
|
| Ahhhhh! See, it helps to UNDERSTAND the problem! I need to read a little more...See if this technique will help:http://www.sqlteam.com/item.asp?ItemID=5857I'm not sure if Full-Text indexing can do this, but you should look into it also, if you haven't already. Books Online has all the details. |
|
|
|
|
|
|
|
|
Massive DataAccess and Parsing Required!