• Welcome, Guest. Please login.
 
September 16, 2021, 11:24:19 PM

News:

Welcome to the SQLitening support forums!


Show posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Messages - Fim

166
Thanks
/Fim
167
Will "slGetUnusedSetNumber" give you zero i any case?
/Fim
168
The test with SELECT * FROM PARTS was done local, not over the lan. It was done from the command prompt with SQLITE3.EXE.  And data was just put into a file, noting more. But the table PARTS has 135 columns so 10 second is very god I think. Therefore I think the execution time of the slSel is 10 seconds.
I will do some test with my method, doing slsel with limit 1000 and try to do updates from another program and see if there are any locking problems. I will report the result.
169
"Like this the database itself is locked only for a very short time."
Short time in my aplication must be <0.5 second.
I tested SELECT * FROM PARTS;  with 53,000 rows, output to a file, about 10 seconds.
So, if I change the LIMIT to 1000, the lock time will be less then 0.5 second and I will call the server with slsel about 50 times. How about that?
170
Remote Mode only.
Ok, suppose I have a program that will do some computation for each part in the table
171
As far as I can see, the database-file is locked for INSERT and UPDATE during the time another process is doing a
172
1 Is too complex for mee
2 Have tested, works fine
3 Is perfect, I use i now.

Thanks
/ Fim W.
173
I know that I can use 'slExe "Create Table If Not Exists ART(...."'
But I want to do other things in PowerBasic when a table does not exist.
Is there a good way to test if a table exist or not?
/Fim W
175
I have a program (PowerBasic) A.EXE which is calling U1.DLL and U2.DLL in order to