FiveTech Software tech support forums

You have to load a recordset before ADO can do its magic. The problem is exactly this loading time.

EMG

Ok. But this was exactly the point. We can't do fast incremental searching using SQL in an engine-independent way. SQL was been designed to be a "query-language" not for the modern interactive applications. EMG Enrico , Something I can't understand - ADODb have .Find( cExpr ) method , whe...

Ok. But this was exactly the point. We can't do fast incremental searching using SQL in an engine-independent way. SQL was been designed to be a "query-language" not for the modern interactive applications.

EMG

You are using LIMIT clause that is NOT standard SQL. EMG mmm yep.. you are rigth.. but you have the equivalent in. Mysql= Select * from clientes limit 10 Sql Server= select top 10 from clientes Oracle=select * from cliente where rownum <= 10 Postgress=select * from clientes limit 10 Sybase= set ...

You are using LIMIT clause that is NOT standard SQL.

EMG

Paging does a good trick when retrieving data is involved... Sorry, but paging can't be achieved using standard SQL, that was my earlier objection. EMG Enrico.. download my class. See the example... See methods PgUp,PageDown,FirstPage,LastPage... a minimal modification on Skip Method, and you have ...

Adolfo wrote:Paging does a good trick when retrieving data is involved...

Sorry, but paging can't be achieved using standard SQL, that was my earlier objection.

EMG

I'm not sure if you already did, but would you please point again to that thread where you publish your tado class? Thank you, Reinaldo. Reinaldo Here you have the post. Download it, try it, comment it http://forums.fivetechsupport.com/viewtopic.php?f=6&t=17178 From Chile Adolfo

... point to consider is that applications usually have a number of different databases (tables) of different record sizes and numbers of records, so choosing which database type (SQL or DBF) is not a simple matter size one may be faster in some situations and the other faster in other situations. ...

I'm not sure if you already did, but would you please point again to that thread where you publish your tado class?

Thank you,



Reinaldo.

Enrico... Paging does a good trick when retrieving data is involved... both on the server ( because the DB and the ADO client supports PAGES ) or by prg code, for instance, I get a 30 items browse and I takes 0,00001 second to get filled, instead of the 4 seconds for the 400.000 items in the test ta...

Adolfo wrote:ADO's is slower when getting data, and also consumes more bandwith when you first call the xbrowse,but... thats all, after the job is done, no more net traffic is present.

This is expected. The slowness in getting data is exactly the problem. But it's not an ADO problem. It's the SQL way.

EMG

Hi.

I'd like to see the SeekIncremental() function code as well, please?

Reinaldo.

Hi everybody. Here you have the results for the test I did. Client PC Pentium 4 1 gb Ram Xp Professional SP2 Ethernet DLink 100mb Switch TENDA 24 + 2 Web Administrable Mysql Server Athlon Xp 2 Gb Ram Linux Fedora Core 8 Mysql 5.0.01 Ethernet Realtek 100MB File Server Pentium 4 4 Gb Ram Windows 2003 ...

Hi everybody..

I did the test this weekend. Got the results ( with some surprises...)

I'm going to tabulate them in an excel sheet, and upload it in an hour.

From Chile
Adolfo