php - Reading from a big table -

-

I want to read data from the table (or view) on SQL Server 2008R2 using PHP 5.4.24 and freetds 0.91 . In PHP, I write: 

  $ ret = mssql_query (select 'mytable', $ Conn);   
 Then I read a line at one time, took action on them, all right. Except, when the table is really big, I get an error:  
  Fatal error: 1073741824 TIRED in the allowed memory size of the bytes / home / test / test (try to allocate 4625408 bytes done). An error occurs in Mssql_query (), so no matter how I query.  
 It is not viable to change the query to return lower rows or lower columns, because I need to read a lot of data from multiple tables in a limited time.  
 To read PHP in one row in a row or to a proper number of times at once?   
 
 
 I agree with @ James in question comments, if you have a table reading such a large amount of your memory Before handing over the PHP to hide the results, it probably means that you need to know a better method though, here is a possible solution (untested and I have used MSSQL only a few times , But if not right then I Do your best):  
  $ ret = mssql_query ('Total Lights' from mytable' SELECT COUNT (*), $ Conn); $ Line = mssql_fetch_row ($ ret); $ Offset = 0; $ Increase = 50; ($ Offset & lt; $ row ['TotalRows']) {$ ret_2 = mssql_query ("IDs offset offset by $ id of offset {$ offset} ROWS FETCH next {$ increment} ROWS ONLY", $ Conn); // // Loop on those 50 rows, do your work ... $ $ offset + = $ increment; } // // There will probably be one remaining, so you have to have an account for it later; It may be wise to make the interior loop a function or method. //

Comments

Post a Comment

Popular posts from this blog

java - ImportError: No module named py4j.java_gateway -

-
I'm trying to call the Python using the Java program py4j . I've been installing the plug-in Eclipse and test name Piidvi project. I'm trying to execute the following part of the code found on py4j webpage: Import from py4j.java_gateway to JavaGateway, java_import gateway = JavaGateway () jvm = gateway.jvm java_import (jvm, '' Org.eclipse Kkorkrisorsej. * ") Vrkspes_rut = Jvankresourkesplginkgetvrkspas (). GetRoot (Gateway .help (workspace_root, '* Projects *') project_names = [project.getName () (for projects workpace_root.getProjects))] print (Projekt_nam) But I There is an error in import. I have checked that the P4JJ is present in the Jar Eclipse plugin directory. Can anyone help please? I had to install the py4j application
Read more

python - Receiving "KeyError" after decoding json result from url -

-
I am new to Python I am trying to parse JSON result from a URL. Basically, I was using the following: response = urllib.request.urlopen (url) json_obj = json.load (response) It should be a stroke "str 'not' bytes' in the lines of a given" JSON object, so after searching on the StackoverView Flo, I decode the response in this way: F = urllib.request.urlopen (Url) charset = f.info (). Get_param ('charset', 'utf8') data = f.read () decoded = json.loads (data.decode (charset)) If I print "decode" I is as follows: { 'link': { 'summary data': 'https: // localhost / piwebapi / streams / p0_7qHaW4UHU-RlCaz8tpasAAQAAAAU0hJTExNQU42NDIwXFNJTlVTT0lE / summary' 'value': 'https: // localhost / Piwebapi / streams / P0_7qHaW4UHU-RlCaz8tpasAAQAAAAU0hJTExNQU42NDIwXFNJTlVTT0lE / price ',' InterpolatedData ':' https: // localhost / Piwebapi / streams / P0_7qHaW4UHU-RlCaz8tpasAAQAAAAU0hJTE...
Read more

c++ - Qt::make_shared for creating QSharedPtr as std::make_shared for creating std::shared_ptr -

-
As stated in the Barjini Stroustrup's "A Tour of C ++", and a known C ++ 14 practice As such, someone should avoid the naked code in the new and delete . Provides std :: make_shared and std :: make_unique to create smart pointers to store allocated items in the standard library. However, it is not possible to use these routines for non-standard smart pointers, such as QT's own memory management model (with parent), but also smart pointer class like Provides QSharedPointer and QPointer (although later it is not actually a brochure indicator). My question is: Is not it convenient to create Qt analog of std :: make_shared ? To like it, QSharedPtr : Namespace Qt {template & lt; Class T, squares ... Args & gt; QSharedPointer & LT; T & gt; Make_shared (erg & amp; ... args) {return QSharedPointer & lt; T & gt; (New t (std :: forward & lt; ergos & gt; (args) ...)); }} or to create this, QPointer : named place ...
Read more