Publishing a SQL Server table of 500,000 rows on the web...

Hi All,

I have tried using some software to convert a 500,000 row table into an .html page.  However, the HTML page gets way too big to open up in Internet Explorer.  Is there any way I can do this?

Thanks!
salesprodAsked:
Who is Participating?
 
Ken SelviaConnect With a Mentor RetiredCommented:
Not that I think it's a good idea, but you might use bcp to extract the data to a text file.

Then convert the file to PDF (here is a free text to pdf converter http://www.verypdf.com/txt2pdf/index.htm)

Then serve the file from a web server.  If the .pdf file has FastWeb enabled, the web server will serve a page at a time, loading in the background after they see the first page, or loading pages as they page to them, or even load them all if you search for some text.

I think Adobe reader could handle 500k rows. That's about 8400 pages.  Adobe reader should have no trouble with that.

Then you can open it with the embeded reader in IE.
0
 
Faiga DiegelSr Database EngineerCommented:
do you have to show that 500,000 row at one time? did you try using paging on your web page?
0
 
salesprodAuthor Commented:
The better solution would be a lookup of some sort, but unfortunately I am limited to html.  Yes, they have to be displayed at once.  How can I do paging?
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
ahoffmannCommented:
> Yes, they have to be displayed at once.
and
> too big to open up in Internet Explorer
then you have to use another browser ..
0
 
Anthony PerkinsCommented:
>>Yes, they have to be displayed at once. <<
I know this is far fetched, but just for a minute, let's assume that you manage to load it in a browser.  Tell me, what user in their right mind is going to scroll through 500K rows?
0
 
salesprodAuthor Commented:
No one is going to scroll through 500K rows.  It would be a lookup tool, used parallel with the Find function.
0
 
ahoffmannCommented:
> .. going to scroll through 500K rows ..
not necessary, you can use for each row
  style="position:absolute;top:0;left:0;"
;-)
0
 
Anthony PerkinsCommented:
Give me a break.  Either that or take some interface clasess.  Or better still talk to your users.  What a concept!
0
 
ahoffmannCommented:
> No one is going to scroll through 500K rows.
then you don't need them in one page (as you stated earlier), so we have 2 contradictory requirements
salesprod, could you please describe more clearly what you want to achieve.
0
All Courses

From novice to tech pro — start learning today.