Re: Mixed pixbuf and text

Jan Hudec wrote:

When you issue a query to a database server, it doesn't return the
results in bits and pieces; it completes the query, and then gives you
everything at once.

This is, fortunately, false about many database servers. When you
execute a query, it gives you cursor. You ask the cursor for lines by
one. It depends on the nature of that query, how much work has to be
done before the first result depends on the nature of the query.

Well, if your database actually sends you the first results reasonably
fast, you can feed say 10 of them to the tree-view, thaw it (you foze
it, right) and let the mainloop run so it can process the events.
Are you sure on this?
My understanding was that the DB server executed the query completely, and *then* gave you a cursor. At least that's how MySQL appears to do things. If I have a query that takes a while to execute, I get absolutely nothing for seconds, and then get all the results at once. For example if I set up a 'pass-through' query in MS Access ( a pass-through query is where Access doesn't process the SQL at all - it just hands it to the DB server and waits for the results ), the results always come back all at once.
Of course I've been wrong before, and will possibly even be wrong again :)


------------------------------------------------------If you are not the CanIt administrator and you think 
message is spam, please give the id 576 and magic value
3af566e289e3 to dan entropy homelinux org to be marked as spam.

NOTE: This message was trained as non-spam.  If this is wrong,
please correct the training as soon as possible.

Teach CanIt if this mail (ID 576) is spam:
Not spam:
Forget vote:

[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]