We have a database of records 7 lacks or more, then we can display with optimum performance?

**kiran2710** · 08-02-07, 08:56 PM

**sk_kireeti** · 17-02-07, 12:14 AM

Kiran,

How are do you want to display records? Is it in SQL*Plus interface or in D2k interface or some other interface? What do you mean by optimum performace? How do you measure it? As far as I know, optimum performance is just a relative term and is never defined or benchmarked.

Thanks,
Krishna

sriodba · 09-02-08, 02:46 AM

optium performance cannot be predicted but u can check the execution plan of the data being retirved using the tools provided by oracle tkprof, stats pack.

mymailbox.21 · 13-03-08, 05:20 PM

we can display any no of records but depends on how we designed the table using normalization rules. if more records exist we can go for partitioning the tables

08-02-07, 08:56 PM	#1 (permalink)
kiran2710 Moderator Join Date: Jul 2006 Posts: 2,184 Thanks: 5 Thanked 371 Times in 255 Posts Thanks: 5 Thanked 371 Times in 255 Posts Rep Power: 58	We have a database of records 7 lacks or more, then we can display with optimum performance? We have a database of records 7 lacks or more, then we can display with optimum performance? __________________ Kiran

17-02-07, 12:14 AM	#2 (permalink)
sk_kireeti Super Moderator Join Date: Feb 2006 Location: Hyderabad Posts: 2,355 Thanks: 117 Thanked 241 Times in 198 Posts Thanks: 117 Thanked 241 Times in 198 Posts Blog Entries: 4 Rep Power: 51	Re: We have a database of records 7 lacks or more, then we can display with optimum performance? Kiran, How are do you want to display records? Is it in SQL*Plus interface or in D2k interface or some other interface? What do you mean by optimum performace? How do you measure it? As far as I know, optimum performance is just a relative term and is never defined or benchmarked. Thanks, Krishna __________________ Give 1 cup rice to a hungry Indian just by a mouse click. No money, no form filling, no hassle... Click here for the donation.

09-02-08, 02:46 AM	#3 (permalink)
sriodba Junior Member Join Date: Feb 2008 Age: 28 Posts: 8 Thanks: 0 Thanked 0 Times in 0 Posts Thanks: 0 Thanked 0 Times in 0 Posts Rep Power: 1	Re: We have a database of records 7 lacks or more, then we can display with optimum performance? optium performance cannot be predicted but u can check the execution plan of the data being retirved using the tools provided by oracle tkprof, stats pack.

13-03-08, 05:20 PM	#4 (permalink)
mymailbox.21 Junior Member Join Date: Mar 2008 Age: 25 Posts: 28 Thanks: 0 Thanked 0 Times in 0 Posts Thanks: 0 Thanked 0 Times in 0 Posts Rep Power: 1	Re: We have a database of records 7 lacks or more, then we can display with optimum performance? we can display any no of records but depends on how we designed the table using normalization rules. if more records exist we can go for partitioning the tables

Thread Tools
Show Printable Version Email this Page
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
interview Q&A asked in winrunner	Spoorthi	Testing Tools & QA	80	22-11-08 11:48 PM
Perl - How to Connect with SQL Server from Perl and how to display database table info?	preethisingh	perl python mysql Interview / Technical Questions	0	26-01-07 11:55 AM
Database testing process in detail	au123	Testing Tools & QA	11	06-12-06 05:08 PM
OS performance	abeetha.m	OTHERS	3	17-11-06 12:43 AM
regarding oracle versions	Madhuri	ORACLE , SQL SERVER , SYBASE & Others	7	07-07-06 07:06 PM