# 2GB on Win7, 64 bit?

**URL:** <https://forums.percona.com/t/2gb-on-win7-64-bit/1563>\
**Category:** Other MySQL® Questions\
**Created:** [November 21, 2010, 5:06am UTC](https://forums.percona.com/t/2gb-on-win7-64-bit/1563 "2010-11-21T05:06:51Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![fre391](https://avatars.discourse-cdn.com/v4/letter/f/f05b48/32.png) [@fre391](https://forums.percona.com/u/fre391)\
**Post date:** [November 21, 2010, 5:06am UTC](https://forums.percona.com/t/2gb-on-win7-64-bit/1563/1 "2010-11-21T05:06:51Z")

</div>

Hi,

Im developing an offline application with Visual Basic on Win7, 64bit. I use MS Visual Studio 2010 Express, MySQL Connector Net 6.3.5(32bit) and MySQL 5.1 (64bit).

I have to insert a lot of records (+20.000.000) given by a XML streamer. To increase speed I already lock tables and disable keys.

During testing I have recognized that MySQl doesn’t seem to use more than 2GB. I have installed 8GB. How can I pass through the 2GB limit? Is the connector the limitation? Does it make sense to switch tothe MySQL ODBC Connector (64bit) to increase the memory usage? As far as I have heard the NET connector is platform indepandant and performance should be (more or less) same.

Thank you very much for feedback on this…

Markus

---

<div class="post-metadata">

**Author:** ![revin](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/revin/32/824_2.png) [@revin](https://forums.percona.com/u/revin)\
**Post date:** [November 22, 2010, 10:49pm UTC](https://forums.percona.com/t/2gb-on-win7-64-bit/1563/2 "2010-11-22T22:49:19Z")

</div>

How exactly do you mean MySQL is limited to a 2GB barrier? How big is your working dataset? What storage engine does your tables use?

---

<div class="post-metadata">

**Author:** ![fre391](https://avatars.discourse-cdn.com/v4/letter/f/f05b48/32.png) [@fre391](https://forums.percona.com/u/fre391)\
**Post date:** [November 23, 2010, 3:09am UTC](https://forums.percona.com/t/2gb-on-win7-64-bit/1563/3 "2010-11-23T03:09:02Z")

</div>

Thanks for your feedback.

Well, currently I use MyISAM. I’ve tried also INNO, but not seen a difference. For the current application I query 25.000.000 recordsets in total, which are placed in 5 tables. Each table has 1-5 coloumns only. No blobs. Biggest table is 13.000.000 recordsets.

Does it help you?  
Thanks again.

Greetings

Markus

---

<div class="post-metadata">

**Author:** ![revin](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/revin/32/824_2.png) [@revin](https://forums.percona.com/u/revin)\
**Post date:** [November 24, 2010, 5:23am UTC](https://forums.percona.com/t/2gb-on-win7-64-bit/1563/4 "2010-11-24T05:23:34Z")

</div>

This might help [http://www.mysqlperformanceblog.com/2007/05/24/predicting-ho](http://www.mysqlperformanceblog.com/2007/05/24/predicting-ho) w-long-data-load-would-take/#comment-211056

How long does loading 25M rows on InnoDB take for you? I just tested loading 34M on stock my-medium.cnf using the sakila.film sample database and it too 19mins average on Linux if this gives you an idea.

I don’t know much about .NET, but have you tried loading your data manually if possible?