Database C#

[Nicostancila]

I'm working to an aplication that uses a database of 7000 records (MS Acccess database). When I load my aplication, it takes a lot of time (to much anyway).I think that I can load my database faster, but I don't know how.Can someone help me? Thank you.

[Stefan Troschuetz]

Nicostancila wrote:

Can someone help me?

It's almost impossible without knowing what you're doing currently. So provide the code of question or at least some more details what you're doing when you load your application.

---

"Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning." - Rick Cook

www.troschuetz.de

[Aaron Dilliard]

Access isn't the best database for a lot of things. It is hard to answer without knowing exactly what you are trying to do, but some suggestions.... If you have a 2 tier application where multiple users connect to the database, Access does not support connection pooling, so you have a lot of connections open to the same database/table. This will slow down Access quite a bit. If the relationships in the database are complex and you are (or are not in some circumstances) forcing the restraints/relations to be upheld in the program, that will drain Access. Are you filling a datatable with a dataadapter? If so, how many times are you doing it? (Check to make sure your sequence of events doesnt load the data twice). If using commands and a datatable, set BeginLoadData=true before reading the data to the datatable, and =false when done. This temporarily keeps restraints from being enforced. If none of that helps, more info is needed. Aaron

[Cl Kurtz]

Hi Aaron, So, which kind of database do you recommmend for applications that require several connections at the same time? For example, a server containing just one database and multiple clients loading from it. Thanks

Kurtz

[TheCardinal]

try loading your data selectively. or filter only the data that you need. :) :badger: