help(advice) for select records from database

Question

HI I need help(advice). I have small c# application and I use access database. In my database i have tblData which looks like this ------------------------------------------------- id-int ai |id_article int |qua double|date date/time| ------------------------------------------------- 1 | 1 | 0 | 28.02.2011 | ------------------------------------------------- The records of this table every day will be incresed about 100 records more. Now my problem is how to select this records becouse for 4-5 monts i will have Thousands of records. now i select records using following sql command: sql_kom = SELECT Table2.NameTable2.PricetblData.quatblData.datetblData.id FROM tblData INNER JOIN Table2 ON tblData.id_article = Table2.id WHERE tblData.date># + date_from + # AND Prodazbi.date I don't know how smart solution is to create new table for every month and insert/read records from that table. Sorry for my bad english :).

Sam Hobbs · Answer

I don't understand what it is that you need help with.

Sam Hobbs · Answer

Thank you Branko. I think I cannot provide the best answer but I think now someone can. Probably the most important thing is to have Table2.id as the primary key of Table2 or at least an index of Table2 and tblData.id_article should be an index for tblData but I am not sure how much all of that is relevant.

branko dimitrioski · Answer

My problem is that about 4-5 months tblData will have a lot of records and i don't know how fast will work my application when selecting that records. How can i speed up query

Suthish Nair · Answer

First of all MS Access size is limited to 2GB only. If your data increases in future i will suggest to move to big databases like SQL Oracle etc..