FiveTech Software tech support forums

... row insert statements) Informix does not support. We need to do single row inserts only. Parameterized queries as suggested above will improve the speeds.

... the brows array. Not all the time. 2) Keep aside all windows and dialogs and folders. Just write small code to read the data and optimize on the speeds. After that you incorporate the windows / folders, etc.. Exactly read data 3) One hint: There will never be any major delays with FWH / (x) Harbour. ...

... tables. You need to optimize this area. Keep aside all windows and dialogs and folders. Just write small code to read the data and optimize on the speeds. After that you incorporate the windows/folders, etc. One hint: There will never be any major delays with fwh/(x)Harbour. Any major delay is ...

... to start the initial main window. It is here the delay occurs and we need to optimize this part. This time mostly depends on the connection speeds, the amount of data we read. We should be *extremely* cautious when dealing with huge tables. When opening very large tables, never to open without ...

... searching on one field at a time or can you search on multiple fields at the same time? I'm going to try the Scope/Filter idea to see what kind of speeds I get. It would let me keep things the same for my current users, however I kinda like this browse search idea. Thanks for all the valuable input ...

... and SetADO() methods, because in both cases the data resides in the memory. Because it is not possible for xbrowse to decide the data access speeds in case of DBFs the choice is left to the programmer who alone can decide the suitability on the basis of the size of the DBF, location of the ...

... only use a oVoice object for all the app, intead of creating it and releasing it many times. I think it may work faster (I have not compared the speeds, its just my guess)

... was limited and computers were slower, we had to consciously keep the string usage and operations to the minimum to achieve faster execution speeds and also to conserve contiguous memory, though Clipper ( and now (x)Harbour ) does the house keeping of garbage collection frequently. With the ...

... see if XBrowse is a lot slower than WBrowse of the same dbf. If the difference is very significant, I can suggest a few ways to improve xbrowse speeds. We can bring the speeds closer to wbrowse but not better.

... connection, same tables, same records. The only thing that's different is the fw component vs a Delphi grid component. We need to compare browsing speeds using the same components over the same connections to the same server where the only variable changing is the SQL engine itself. Doing this ...

... power for complex queries. Calculations are done on the server and only summary comes to server reducing network traffic and also highly improves speeds. Free from the limitations of DBFCDX, importantly size. Better performance with more concurrent users and larger tables. CONS: Cost Porting problems ...

Hi Carlos,

yes, I don't write in sample, sorry.

Did you ever try to compare speeds ads using sql with normal way?

thanks

regards,

kok

... because most of the time is spent reading the disk which is hardware dependent. As I mentioned earlier, most of the times it is the data access speeds that decide the total time taken. Optimizing the code execution speeds does not yield perceptible time savings. In any case for this kind of ...

The above code works quite fine on small and medium databases. More time is spent on data access than on code execution. Data access speeds can vary for the same code at different times depending on various factors, including whether some parts of the data requested are already in the cached ...

... itself. FWH endeavors to provide what many programmers want. May be this will be provided sooner or later. Before that we need to achieve best speeds with ADS. I have later improved the above sample further to almost avoid calling OrdKeyNo(). In such a case it should not matter if it is ADS ...