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 |
|
voyager838
Yak Posting Veteran
90 Posts |
 Posted - 2009-03-16 : 04:39:47
|
| I have a large database with 40 GB data! what would be the fastest/effective way for quickly select set from it, with a querys?Could paging data be good technique or only somekind of index method be better? Is it possible to combine these to to get an faster access ?It should be remainded that the data here only is for reading, not deleted or changed. |
|
|
pootle_flump
1064 Posts |
Posted - 2009-03-17 : 07:16:53
|
| These are not two either\ or conditions.What size are the sets? One row or 5, 000 rows? Where\ how are they displayed? |
 |
|
|
voyager838
Yak Posting Veteran
90 Posts |
Posted - 2009-03-17 : 18:42:54
|
| atleast 5000 rows or more.i want to search on a data that are stored like thisdatetime | col 1 | col 2 | col3 | ... | col n2008.01.01 00:00 | 0.32 | 13.0 | 2.1| ... | 0.1 2008.01.02 00:10 | -1.2 | 1.0 | 0.1| ... | 1.32n here can be pretty huge and also the rows of course.Let say that i chunk over 500 000 rows x 30 if i select these data, it would take a while to import it, and i guess it would not have to be necessary,beacuse i can't the fact see more than maby 100 rows in time.But how i don't know how/which technique to use for getting the rows smoothly, effective as possible. |
|
|
|
|
|
|
Paging data or indexing