PureBasic Forums - English

Perhaps a "tricky" way to solve by the moment the issue:


SELECT MIN(date), typeof(MIN(date)) FROM table


With the above code the second column has the type of the first so I have to parse the columns queried between SELECT and FROM and add the same number of columns for type or save the ...

Thanks Paul.

I hope there is a solution for this issue because I have only one idea to solve this myself, it is parsing the query instance... too much hard for me.

Thanks pdwyer.

Yes, GetDatabaseString runs ok and I can get the date, but the problem is when type of column is not defined on compiling time, when you don't know the query, when query is definied on runtime.

Any idea how get the type easily? Thks.

I'm using SQLITE engine of PB.

If I send a request with this query:


SELECT date FROM table


DatabaseColumnType returns for the first column (0) after DatabaseQuery: 2, this is right because "date" field is a date as its name means.

But with this query:


SELECT MIN(date) FROM table ...

@pdwyer:

Hehehe, I was talking with Psychophanta and "our" country so she is the foreign

Good one.

@Psychophanta:

Interesting your comment of science computer, Cell processor and PS3. Of course many universities has a grid/farm/cluster/blade... of "standard" computers but OS is a litle bit hacked for add the performance of all of them, isn't it? So is a niche market.

On the other hand there are ...

After all I have found a misstake, you are right Trond! a delay(1) is in between spaghetties. Simplifying:


Repeat
EventServer = NetworkServerEvent()
If EventServer
Select EventoServidor
...
EndSelect
EndIf
Delay(1)
Until Quit = 1


If I delete Delay (1) I obtain a 100% used CPU but with ...

Reason to use x64:
Take time to prepare yourself for the next OSes. HW is important and goes fast but it goes fast basically because every day OS and apps need more resources... and maintain two versions is too expensive for OS developers and hw manufacturers (drivers) so take time to be prepared to ...

Many many thanks Trond for the code, I seem very lazy...

I have done some tests, these are the results:

Showing all the message, in every step: 110ms - 150 ms total time
Showing only few steps with modulo % 10 : 32ms total time
Showing only final step: 15ms total time

So it seems is very fast, I ...

I will double check again the code but I have not found any error til today.

Fields are around 20, 1 million or more is technically impossible on a nowdays monitor Trond :wink:

I will create a test program, with server and client simplifying the code to get the speed of the system because Trond ...

Thnks Mahan and Trond.

I am starting with a "packing" or "serializing" function after that I will add a function to crypt the data and after a compression routine, or perhaps mixing both.

Anyone knows which algorithm is better for a short data length?

Thanks

I have done more tests and the global time is too high. Client show a "gui form" and it needs around 1s to fill all fields... so it doesn't good performance. I suppose I will improve the comms if in "reports" I send together some rows but this is not possible in a form gui.

Perhaps a way to improve ...

Hi! Thks though we have not success.

At the beginning, reading your post, I thought oops I didn't understand the way to use the command, I thought that DataBufferLength is the size of the buffer but looking your pseudocode I thought it is the length of the frame so I implemented, but not success ...

I'm programming a client-server application using the networking commands included with PB.

Afer doing some test in the local machine, with both , client and server, I have found ReceiveNetworkData is a very slow command in my application, checked with EllapsedTime before and after the funciton. It ...

Yes, PDFFill can do the job, we use it to create our forms, it allows too put buttons and so on too. This program is a must together with Foxit Reader. Cheap and powerful.