Fastest way to get a single value out of Access-Database

3.1 ms sounds pretty good to me.

However, if you're serious, then you could try:
- checking you have the right indexes
- maintaining your database connection (if not already)
- using DAO instead of ADO
- using RAID
- overclocking your CPU
- getting a faster computer
- loading your whole database into RAM, before use
HTH <g>

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode test 33Switch to Hybrid Mode Switch to Threaded Mode

1 5th April 22:03 jason keats External User Posts: 1	Fastest way to get a single value out of Access-Database 3.1 ms sounds pretty good to me. However, if you're serious, then you could try: - checking you have the right indexes - maintaining your database connection (if not already) - using DAO instead of ADO - using RAID - overclocking your CPU - getting a faster computer - loading your whole database into RAM, before use HTH <g>