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 |
|
kevincallan
Starting Member
13 Posts |
 Posted - 2008-05-13 : 15:57:17
|
| How do you all recommend storing ordered pairs in SQL Server 2005? I plan to add one record for every data point but this will generate many records and requires an extra field to relate the points together. Are there any better ways to do this? Can the data still be searchable or does it have to be unpacked first? |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-05-13 : 16:33:36
|
Do you have an example of an ordered pair, and it's use?
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
kevincallan
Starting Member
13 Posts |
Posted - 2008-05-14 : 11:40:28
|
| The ordered pairs define an intensity vs wavelength description for a laser diode array. There are about 3500 points per capture. An example snippet follows. I am collecting datasets from three spectrometers with differing wavelength ranges and capturing about 10 datasets from each spectrometer during each test. That's about 3500 x 3 x 10 = 100K ordered pairs per test and we run about many tests per day.832.0, 1507.2832.1, 1509.0832.2, 1522.4832.3, 1589.2... |
|
|
|
|
|
|
Storing large arrays of ordered pairs