help(advice) for select records from database

Feb 28 2011 10:13 AM
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.Name,Table2.Price,tblData.qua,tblData.date,tblData.id FROM tblData INNER JOIN Table2 ON tblData.id_article = Table2.id WHERE tblData.date>#" + date_from + "# AND Prodazbi.date<#" + date_to + "# AND Table2.group='2'";


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 :).

Answers (4)