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?

Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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?
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?
> Yes, they have to be displayed at once.
> too big to open up in Internet Explorer
then you have to use another browser ..
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

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?
salesprodAuthor Commented:
No one is going to scroll through 500K rows.  It would be a lookup tool, used parallel with the Find function.
> .. going to scroll through 500K rows ..
not necessary, you can use for each row
Anthony PerkinsCommented:
Give me a break.  Either that or take some interface clasess.  Or better still talk to your users.  What a concept!
Ken SelviaRetiredCommented:
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

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.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
> 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.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Web Applications

From novice to tech pro — start learning today.