FiveTech Software tech support forums

It's been two days since I've had anything to do with Python! DESKTOP PC with Windows 11 pro: Processor: Intel(R) Core(TM) i9-10920X CPU @ 3.50GHz, 3504 MHz, 12 core(s), 24 logical processor(s) Data carrier: Samsung SSD 970 EVO Plus 1TB 64GB RAM NVIDIA RTX 2080TI First attempt, without GPU support (...

Hello Antonio, From the looks of it, the training doesn't just happen in one round: First round generated a 715MB file "cached_lm_GPT2Tokenizer_128_fivetech_forums_20231222.sql" in 16min. The second round is actually the training and I'm now at 0% after 47 minutes and the open duration is ...

python is 3.12 pip is uptodate antivirus is stopped ? C:\fwh\AI>pip install pytorch Collecting pytorch Using cached pytorch-1.0.2.tar.gz (689 bytes) Installing build dependencies ... done Getting requirements to build wheel ... done Preparing metadata (pyproject.toml) ... done ...

... fast < 3 Secs building the recordset. The memory consumption gets to max 600Mb. I can have > 50 recordset opened at same time. With the cached recordsets memory consumption will not increase. AdoRdd can cache the recordsets in the beginning of the application with: SET ADO PRE OPEN THRESHOLD ...

... To avoid cache for ex other historic tables with same name. Please remember that even we dont use this SET every time a table is opened it will be cached. Again if any of those tables have millions of records if we dont have any query to limit the nr of records returned adordd will load all those ...

... SET TRESHOLD was not finding aMask if used table and SQL were with different case. Now all upper case. 5) Pre opening of recorsets optimized and cached for different where clauses on same table. If the table its below the SET THRESHOLD and its already opened in another work area the set its not ...

... SET TRESHOLD was not finding aMask if used table and SQL were with different case. Now all upper case. 5) Pre opening of recorsets optimized and cached for different where clauses on same table. If the table its below the SET THRESHOLD and its already opened in another work area the set its not ...

Gunther,

It should be closed auto by adordd.

When you end your app (x)Harbour auto calls ADO_EXIT that calls ADODB_CLOSE().
This last closes all tables (recordsets) and cached resordsets and after the connection to the server.

Please check the code.
Is it not working?

... Usually yes for two reasons: 1. much smaller indexes what is significant when index files are accessed by network or they are two big to be cached by system in local access. 2. In NTX format record number is not part of index key. It means that after GOTO or when record is modified NTX RDD ...

... file until after skip is complete. This is to ensure that the index tree has not changed until after the next record is resolved. Having the locks cached is not the best idea when each users machine is managing the indexes. If you are using client/server then there is no problem.

... the query. If the cursor handle was not explicitly closed by calling AdsCloseSQLStatement, the underlying table(s) will remain open in a "cached open" state by the Advantage server to improve the performance of subsequent queries. However, this "cached open" state will cause ...

Avista; Most SQL engines can execute a prepared query, also known as a unnamed parameters in SQL. When such SQL executes it is cached by the server and optimized to be executed many times. Each time you execute the SQL you'd only need to change the values for the parameters. Example: ...

... you are running, the response I get for example 50 sec. When I send the same query again, the response I get for example, 1.2 sec. The reason is cached internally in the MySQL database. When I start the program, in the folder there are several ComboBox and ... ON CHANGE FunX (); Function FunX() ...

... the SQL query. When executed for the first time, takes on a large base for a long time. Another time, when he executed the same query is already cached and executed significantly shorter. By optimizing queries and good indexing applications work very well with large databases. Summary, Mr. Rao, ...

... query, rather than opening an entire table, seeking and filtering data. One thing to keep in mind using recordsets is that they are local ( cached ) to the workstation that opened them and in a multi-user environment you need to keep in mind data visibility. Meaning, if I have a workstation ...