Thanks for reply....
I am developing a website of e-commerce.
and database has 16000 records.
actually I have 3 tables.
and all 3 tables contain details of products.
productid is primary key for all 3 tables.
all 3 tables contain detail of different products
but
some products are same and i have to display
that product in my site.
so i have to find productid which
is common in all 3 tables.
so i have to access all data.
and i have to display top 5 selled product.
my database knowledge is not so good.
so pls help me...
--- Dean Fiala <[EMAIL PROTECTED]> wrote:
> I'd ask why a user would need or even want 16,000
> records on a single
> page. If you need to perform some sort of batch
> work on the records,
> do it in the database or in a class in a separate
> thread.
>
> > From: [email protected]
> > [mailto:[EMAIL PROTECTED] On
> Behalf Of nidhi upadhyay
> > Sent: Monday, November 07, 2005 11:36 PM
> > To: [email protected]
> > Subject: [AspNetAnyQuestionIsOk] Timeout
> expired........
> >
> >
> > hi...
> >
> > I m working with sqlserver database.and
> database has 16000 records.
> > I m developing web site.
> > but when i will try to run first page then
> sometimes...it displays
> > following error..
> >
> > "Timeout expired. The timeout period elapsed prior
> to completion of the
> > operation or the server is not responding. "
> >
> > On this page I have to fetch all 16000
> records.
> >
> > pls help me..........................
> >
> >
> > ---------------------------------
> > Enjoy this Diwali with Y! India Click here
> >
> > [Non-text portions of this message have been
> removed]
> >
> >
> >
> >
> > SPONSORED LINKS
> > Basic
> >
>
<http://groups.yahoo.com/gads?t=ms&k=Basic+programming+language&w1=Basic+pro
> >
>
gramming+language&w2=Computer+programming+languages&w3=Programming+languages
> >
>
&w4=Java+programming+language&c=4&s=126&.sig=bnac3LCZpttb3c9FvbVU-A>
> > programming language Computer
> >
>
<http://groups.yahoo.com/gads?t=ms&k=Computer+programming+languages&w1=Basic
> >
>
+programming+language&w2=Computer+programming+languages&w3=Programming+langu
> >
>
ages&w4=Java+programming+language&c=4&s=126&.sig=1Czd2hKCO9_u4KVZQperFQ>
> > programming languages Programming
> >
>
<http://groups.yahoo.com/gads?t=ms&k=Programming+languages&w1=Basic+programm
> >
>
ing+language&w2=Computer+programming+languages&w3=Programming+languages&w4=J
> >
>
ava+programming+language&c=4&s=126&.sig=TyHGCjod4YOKITrSq1xccQ>
> languages
> >
> > Java
> >
>
<http://groups.yahoo.com/gads?t=ms&k=Java+programming+language&w1=Basic+prog
> >
>
ramming+language&w2=Computer+programming+languages&w3=Programming+languages&
> >
>
w4=Java+programming+language&c=4&s=126&.sig=PZAexF9LyXpKb3HDJSlB1g>
> > programming language
> >
> > _____
> >
> > YAHOO! GROUPS LINKS
> >
> >
> >
> > * Visit your group "AspNetAnyQuestionIsOk
> >
>
<http://groups.yahoo.com/group/AspNetAnyQuestionIsOk>
> " on the web.
> >
> >
> > * To unsubscribe from this group, send an
> email to:
> > [EMAIL PROTECTED]
> >
>
<mailto:[EMAIL PROTECTED]
> > e>
> >
> >
> > * Your use of Yahoo! Groups is subject to
> the Yahoo! Terms of Service
> > <http://docs.yahoo.com/info/terms/> .
> >
> >
> > _____
> >
> >
> >
> >
> > [Non-text portions of this message have been
> removed]
> >
> >
> >
> >
> >
> > Yahoo! Groups Links
> >
> >
> >
> >
> >
> >
> >
> >
>
>
> --
> Dean Fiala
> Very Practical Software, Inc
> http://www.vpsw.com
>
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
------------------------ Yahoo! Groups Sponsor --------------------~-->
Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life.
http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/saFolB/TM
--------------------------------------------------------------------~->
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/