Need informayion on Databases

[Cdextraze]

I have done a program that access cdb with ADOCE but there a huge problem, it is way too slow!!!

So I am looking at alternate way, it seem CCeDBDatabase are working only with WCE databases and I am not sure about the CEOpenDatabaseEX.

So my question is, do you think I can make it work with the last one or if not is there an other way that I could use my database with more speed than ADOCE???

thanks for your time
Christian

[famousdavis]

What are the characteristics of your database? How many tables/rows in it? What program are you using for forms? You're sure you don't have an issue that an additional index wouldn't resolve? What hardware are you using?

I only using ADOCE, and although it's terribly limited, it can barely meet the needs I have for it. My database is slow, too, even though I probably have fewer than 1000 rows across all 20-odd tables that I've created. But then, I'm running on an hp1910 PPC!

[Cdextraze]

Well my database have around 30-40 tables with some with 2 rows and some other can go up to 1000 rows!
Accessing one table is no problem, but it when I do a requery(well with a lot of while and if) with inner join and the like it could take up to 30 min for the result to appear and that do not mak sense...
I use a Database created in Access 97, then I transfert it in my pocket PC with activesync.

I am using ADOCE 3.0 do you think that ADOCE 3.1 could be any beter?
thanks again for your time :)

[famousdavis]

Well my database have around 30-40 tables with some with 2 rows and some other can go up to 1000 rows!
Accessing one table is no problem, but it when I do a requery(well with a lot of while and if) with inner join and the like it could take up to 30 min for the result to appear and that do not mak sense...
I use a Database created in Access 97, then I transfert it in my pocket PC with activesync.

I am using ADOCE 3.0 do you think that ADOCE 3.1 could be any beter?
thanks again for your time :)

Good gravy! With so little data, if any of your queries are taking more than a few seconds, then something is wrong, and I'd guess it's a performance issue with your code and/or table design. I have a database where I am joining four tables together in a single form, and while the form is slow, it still pops up the entries to all the form fields in about a second or less. However, I'm not using any macros that have if/then logic.

What are you using for your forms development?

Can you copy some of the code you're using in your form to do the table joins?

[Cdextraze]

Thanks for your time I just find out what was my problem!! It was me lol I did so major error in my coding that was slowing way to much! but now I use the right requery and it working a lot faster!!! Like you say in second.

Well thanks again for your time and and a least the best side of making error is that I learn from them!!!

take care
Christian