|
-
 Originally Posted by annideon
Hello
I'm looking for help with a database design problem...
I have 1300 data items, 3300 company tickers, and dates (making this time series data).
The data items grow by a few a month. The company tickers grow by one or two per week. And dates that grow by one per day. <SNIP ...> how should I design this so it optimizes my queries? <SNIP ...>
Even though the original question was posted 3 years ago, I contribute the following for future reference. I agree with @GolferGuy , follow standard relational database design standards, and normalization techniques. Use the links I post below to optimize the Jet Database Engine (or Access Database Engine), until you've outgrown it. Then migrate to a faster engine, like SQL Express, MS-SQL, Oracle, mySQL, Postgre SQL, etc.
Microsoft Access Performance Tips
Speeding Up Microsoft Jet database engine Operations
Use Jet Engine Optimizations to Speed Up Queries
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|
Reply With Quote